Hello Guys!

I have a tabe with 2 fields


One Two in that format

One Two
ACSEK AC01
ACSEK AC02
MOPE AC01
MOPE ACME
MOPE AC04

I would like to select the data so that in the display it comes up like this

ACSEK AC01, AC02
MOPE AC01, ACME, AC04

using a select statement

Any ideas?