How do I combine multiple entries into one?

[Guest]

Is it possible, in a query in access, to group all the employees for, say
Building A, into one field? So the end result is
1st record: "Building A"::"Abe, Bonnie, Clyde."
and
2nd record: "Building B"::"Doug, Elvin, Fran, Greg".

I know that if you use the "&" in between adding cells in Excel (=A2&"
"&A3&" "&A4&" "&A5), you can output a text string. I suppose i'm looking for
the sum equilavalent for text.

 

[Douglas J. Steele]

How's your data arranged? For the sample you're showing, do you have 7 rows
of data? If so, take a look at
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web"