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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Example: [Attendees] field returns 5 names. I want to display these names
in sequence, divided by commas, on a report.
 
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?

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

--
Duane Hookom
MS Access MVP


Mudpuppy said:
Example: [Attendees] field returns 5 names. I want to display these names
in sequence, divided by commas, on a report.
Click to expand...
Click to expand...
 
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


Mudpuppy said:
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?

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

--
Duane Hookom
MS Access MVP


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