Combine records to one field with commas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top