how do I concatenate text from the same field in separate records

[Guest]

I need to combine the text in the same field of multiple records, grouped by
another field, to turn out a report showing only the grouped data.

 

[kingston via AccessMonster.com]

Refer to this post:

http://www.accessmonster.com/Uwe/Fo...-values-into-a-single-record#688a5501f31ccuwe


The only difference is that you'll have to add a criteria for the group. I.e.
update the data where the group number matches.

 

[Duane Hookom]

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