If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Convert grouped records into a string
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. |
Thread Tools | |
Display Modes | |
|
|