Concatenate Data Across Records

C

cw

I am trying to bring data across records together. Not sure if this can be
done in Access.

CompanyName Products
Test1 Cups
Test1 Plates

Would like a table/query etc to bring the record together "Concatenate" the
fields.

CompanyName CombinedProducts
Test1 Cups, Plates

Any ideas on how this can be done? I basically want to group on the company
name and then consolidate all the products associated to the Company name
into one field CombinedProducts.

Any help is GREATLY APPRECIATED!
 
C

cw

I found an unanswered (but really answered) question that had what I needed.
Thanks Duane Hookom!!! For the wonderful Concatenate query/logic!!
 
C

cw

OK - Unfortunately,... It did not work for me. I am getting error message on
the vb code - and unfortunately, I am not experienced enough to fix it. Does
anyone have another fix for concatenate?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking consecutive records to previous record in a query 1
Sum(IIF statement 1
How do I query companies not having members w/certain level of mgm 5
Transposing data in Access 2007 Query 1
Sorting 2
SELECT query field conversion 2
Update Query not working 4
Concatenate Problems 11

Top