Combining data into a single string

[bosk00]

I have a query that displays information that has been selected with checkbox's on a continuous form. The data is state abreviations. Say the user selects Alabama, Arizona and California. The queries output shows AL, AR, and CA as 3 seperate lines. Is there a way to combine them? The desired output would be 1 line with "AL, AR, CA". Thanks for the help.

Alan
Senility at its finest

 

[lespaul]

There is a public function that was written to do this in Thread700-866768

you should be able to paste it directly into a module and run your query with it as shown and you'll get the results you are looking for.

leslie

 

[dhookom]

The mentioned thread works well for a single usage. Check

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

for a generic function for concatenating multiple child values.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.