[AccessD] Heck of an Access Question

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