Concatenate in a Group By?

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Is there a way to use a group by clause and then concatenate the string
values in a field of the grouped records separating them by a comma?

E.G.
Query:
Item Bin
2244 01-A1
2244 06-B2
3355 01-B2

Resulting:
Item Bin(s)
22444 01-A1, 06-B2
3355 01-B2

TIA,
Dan
 
Back
Top