[AccessD] Heck of an Access Question

No.  There are only two questionnaires.  Active
customers and inactive customers.

Anyone that has purchased within the last 12 months in
an active customer.  Anything over that is an
inactive.

The forms themselves are not dynamic in which
questions they ask.  The only dynamic part of the form
is the contact information and the items that they
purchased.  Which is what we're trying to distill down
to one record per customer.

A customer may have purchased one, two, three, or more
items in their last purchased.  The program (SAP) that
is used o invoice the customers creates a distinct row
for each item purchased, but the customer info and the
invoice number all match.  So, based on the customer
info and the invoice number I need to distill all
records, for that particular purchase, into one record
with the non-matching items, like the purchased items
descriptions, concatenated into one field in the
record.

Basically, turn.

Joe   11911     vaccuum
Joe   11911     cleaner
Joe   11911     duster

Into....

Joe   11911     vacuum, duster, cleaner

--- "Mitsules, Mark" <Mark.Mitsules at ngc.com> wrote:
> Frank,
> 
> Do the purchases or number of purchase have any
> bearing on the number or
> types of questions in the questionnaire?  I'm
> curious why you are dealing
> with sales detail records.  It seems like you should
> have access to the
> "Customers" table...or at least a copy or subset of
> that table.
> 
> 
> 
> Mark
> 
> 
> 
> -----Original Message-----
> From: Frank Tanner III [mailto:fbtanner at yahoo.com] 
> Sent: Tuesday, October 21, 2003 3:19 PM
> To: Database Advisors
> Subject: [AccessD] Heck of an Access Question
> 
> 
> Ok.  I have a doozy of a problem this time.  My
> Marketing department has tasked me with creating a
> database/questionnaire
> for our customers.
> 
> In the data that I am going to be given, each
> customer
> has a specific customer number, however, based upon
> how many items that they purchased on their most
> recent invoice, they might be in the table multiple
> times.  If they purchased one item, they're in one
> time.  Two items, two times.  Et al.
> 
> My problem is this.  I need to "convert" these
> multiple entries into a single entry concatinating
> all
> of the non-matching data.  Such as items purchased. 
> Obviously, their customer info should be the same.
> 
> Any assistance that you can give me would be greatly
> appreciated.  Thank
> you. _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com