DatabaseDuane
asked on
Gathering data into single field
I need to export data from Access that goes into a spreadsheet that aggragates many items into one field. It would take data like this:
CustomerID PayID Date Amount
3455 47 1/1/2010 $10
3455 99 7/1/2011 $90
5544 54 6/5/2010 $25
and creates one long text field displaying the records like this:
Customer ID Text
3455 1/1/2010 $10, 7/1/2011 $90
5544 6/5/2010 $25
It will allow for single line excel record viewing.
Any suggestions how to build a table or create a query that aggragates the data?
CustomerID PayID Date Amount
3455 47 1/1/2010 $10
3455 99 7/1/2011 $90
5544 54 6/5/2010 $25
and creates one long text field displaying the records like this:
Customer ID Text
3455 1/1/2010 $10, 7/1/2011 $90
5544 6/5/2010 $25
It will allow for single line excel record viewing.
Any suggestions how to build a table or create a query that aggragates the data?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is an incredibly elegant solution. Thank you.
Open in new window