Concatenate fields in multiple records into one record

[Seadog]

Sample database:

Field 1 Field 2
abc x1
abc x2
abc x3
def y1
def y2
def y3
ghi x1
ghi y2
ghi y3

I would like to run a query that would consolidate Field 2 into one record so the results look like this:

Field 1 Field 2
abc x1, x2, x3
def y1, y2, y3
ghi x1, y2, y3

Any ideas?

 

[tehNellie]

Crosstab Query.

Doesn't concatenate them per se but pivots the data to give an output in that format.

 

[John Big Booty]

Perhaps this is the sort of thing you are looking for?

 

[Seadog]

That works. Thanks!

 

[datAdrenaline]

I personally find the code found here named MakeCSV() to be easier to use and more flexible --- Not that I am biased or anything