Combine records to one field with commas

[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

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

That is exactly what I was looking for!

Thank you,
Dave