Combine more records in one, using comma delimited

[dim]

Hi,

I'm new here and new Access user.
I'm looking for an easiest solution to combine more records into one, using comma delimited.
Let’s say that I have a table T1 with two columns Code and Client like this:

Code Client
X C1
X C2
Y C1
Y C3
Z C1
Z C2
Z C4
Z C5

i need to see those records in a Query, grouped by "Code" with the Client's value combined like this:

Code New
X C1, C2
Y C1, C3
Z C2, C4, C5

Please Help,
Thanks

 

[GinaWhipp]

Have a look at...
http://allenbrowne.com/func-concat.html

 

[dim]

For GinaWhipp: Thanks a lot!
Is perfect!

Have a great day!

 

[GinaWhipp]

You're welcome!