How do I concatonate the tevalues in a field in a query into a sin

[Guest]

Example: [Attendees] field returns 5 names. I want to display these names
in sequence, divided by commas, on a report.

 

[Duane Hookom]

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

 

[Guest]

Duane ... Based on your samples, I wrote the following statement:

List: Concatenate("SELECT AttName FROM tblAGAtt WHERE AGMtgID =" & [AGMtgID])

and received and error message that "concatenate" is not a recognized
function. I'm working in Access2002. Any Ideas?

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

--
Duane Hookom
MS Access MVP

Example: [Attendees] field returns 5 names. I want to display these names
in sequence, divided by commas, on a report.

 

[Duane Hookom]

Your function should be saved in a standard module. The module name must not
be the same as the function name. Your expression looks fine assuming
AGMTgID is numeric.

--
Duane Hookom
MS Access MVP

Duane ... Based on your samples, I wrote the following statement:

List: Concatenate("SELECT AttName FROM tblAGAtt WHERE AGMtgID =" & [AGMtgID])

and received and error message that "concatenate" is not a recognized
function. I'm working in Access2002. Any Ideas?

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

--
Duane Hookom
MS Access MVP

Example: [Attendees] field returns 5 names. I want to display these names
in sequence, divided by commas, on a report.