Convert grouped records into a string

I am trying to convert all the names I have listed in a grouped query into one string record. For example, I am 1) grouping my records by date, 2) each date has a number of records for who was absent that day. I want to convert those names of absentees into a string:

4/1/04 Bob
4/1/04 Bill
4/1/04 Betty
4/3/04 Dave
4/3/04 Dan

....would become...

4/1/04 Bob, Bill, Betty
4/3/04 Dave, Dan

Any help would be....well...helpful.

There is a generic concatenate function with samples at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

--
Duane Hookom
MS Access MVP


"mmattson" wrote in message
...
I am trying to convert all the names I have listed in a grouped query into
one string record. For example, I am 1) grouping my records by date, 2) each
date has a number of records for who was absent that day. I want to convert
those names of absentees into a string:

4/1/04 Bob
4/1/04 Bill
4/1/04 Betty
4/3/04 Dave
4/3/04 Dan

...would become...

4/1/04 Bob, Bill, Betty
4/3/04 Dave, Dan

Any help would be....well...helpful.