Combine records to one field with commas

D

dave k

I want to write a query or use vba to combine a field from multiple records
into one records summarized by one field with the second field holding all
the variations separated by commas. For example, if data was:

Field 1 Field2
User1 A
User1 C
User2 A
User2 B
User2 D

the results would be something like:

Field 1 Field2
User1 A, C
User2 A, B, D

Any ideas on how to do this?

Thanks,
Dave
 

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

Top