concatenate single field

[Rizza]

Would anyone point me to a function or SQL that would concatenate all of the
records for a single field into a single field while using a group by. What
I am desiring is to write something similar to the first or last function
but I want all records (of one field) in one record in one field.

 

[Rick Brandt]

Would anyone point me to a function or SQL that would concatenate all of the
records for a single field into a single field while using a group by. What
I am desiring is to write something similar to the first or last function
but I want all records (of one field) in one record in one field.

What, separated by commas? How many will there be (worst case)?

 

[Gina Whipp]

Rizza,

Have a look at Duane Hookom's - Generic Fucntion to Concatenate Child
Records:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Rizza]

Ha it is not a function OR SQL it is both. This is exactly what i was
looking for.

Thanks

 

[Gina Whipp]

You're welcome!