Consolidate Multiple Rows into Single Row

[bkf7911]

Is there a way to consolidate Multiple Rows into a single row?
I'd like to place all values related to Field1 into a single field, separated by a comma, perhaps, rather than have them as individual rows. I can use Access, VBA, SQL, Excel to accomplish. Any ideas how i can do this?

EXAMPLE:

Field1 Field2
A1 B1
A1 B2
A1 B3
A1 B4
A1 B5
A1 B6

Revise to

Field1 Field2
A1 B1, B2, B3, B4, B5, B6

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886