Access concatenate/consolidate fields query.

[deevaetodin]

Hello;

I currently have an Access table that has a field that uniquely identifies a customer with a number. Along with the customer number is their name and their product purchased. How do I do the following to the table

Customer Name Product
1 Joe a
1 Joe c
3 Sam a
5 Jane b
5 Jane c
5 Jane d
5 Jane e

Make this so that my table reads as follows, the multiple products in their own distinct field would be great (e.g.fields Product 1, Product 2, Product 3, etc....)

Customer Name Product
1 Joe a,c
3 Sam a
5 Jane b,c,d,e

Any help is very much appreciated.

Thanks D.