Concatenate query results

[Del]

I have a parameter based query that returns a single column of names.

Example:

John Smith
Goerge Johnson
Mary Jones
.....
....
....
....
etc.

What I want to do is concatenate these names into a single string;

John Smith, George Johnson, Mary Jones, ..., ..., ..., ..., ect

Thank you!
Regards,
Del
N8OFP

 

[Jeff Boyce]

Del

Check Duane Hookom's function:

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


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/