Concantenate multiple rows into single row 2

[Cordeiro82]

I have a table that looks like this

User Tcode
AMarlet V1100
AMarlet V2845
AMarlet F110N
BWilliams F110N
BWilliams V1100

Is there any way I can get it to condense the multiple rows into something like this:

User TCode
AMarlet V1100, V2845, F110N
BWilliams F110N, V1100

Any help would be appreciated=)

Thanks,

Kevin

 

[Remou]

There are a couple of FAQs on concatenation in the Access Forums. One of them should suit.

 

[PHV]

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886