Group by - Concatenate

[Jeremy]

Does anybody know how to run a group by query and have one
of the fields 'concatenate'. For example, if I have two
fields (names, comments) is there any way to group by the
names and then have a corresponding "cell" which contains
ALL of the comments for that person. This would be kind
of like having groups on a report, but listing the data
horizontal rather than verticle. Can this be done?

Thanks!
Jeremy

 

[Duane Hookom]

There is a generic function and examples of usage in a download at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.