What is the fastest way to denormalize data? 1

[hneal98]

I have a table like this:

field1 field2
a aa
a ab
a ac
b ba
b bb
c ca
c cc
c cd

I would like it to look like this:

field1 field2
a aa,ab,ac
b ba,bb
c ca,cc,cd


What is the best way to do this in Access? Am I going to have to do some VBA code?

Thanks

 

[Remou]

Have you seen:
faq701-4233

 

[hneal98]

I hadn't seen it, but it works perfectly.

Thank you,

Harv