Concatenate names of attendees

[Guest]

I would like to have in the CarName group header, a concatenated list of
people in that vehicle. I have a query (qry_ArrivingPassengers) that
contains the LastName and CarName for all arriving vehicles. My report
groups on the CarName. I will need a Departing passenger string of text also.

How do I go about concatenating the list of people in each of the cars?

 

[Duane Hookom]

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