Consolidate records

[mwarnimont]

This is the table I have:

CustID Item DatePurch
1 11a 08/20/02
1 11a 10/21/02
1 8f 08/11/02
2 12c 07/21/02
3 17a 09/02/02
3 11a 08/19/02
3 17a 08/18/02

I need to come up with a way to get a report to show these results:

CustID Item DatesPurch
1 11a 08/20/02, 10/21/02
1 8f 08/11/02
2 12c 07/21/02
3 11a 08/19/02
3 17a 08/18/02, 09/02/02

Any ideas?

Thanks!

 

[essnrv]

First you need to query ORDER BY Item,CustId and then format it programetically Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!