Transpose Data

[bdjb]

Hello,
I have training data in a table, with each row containing a clas, class time and attendee. The user would now like a report that groups the clas by date, and shows each of the attendees on one line. Is there a way to concatenate them into one field?

Using MS Access 2003.

Thanks for your help in advance

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886