Concentate Many Table 1

perrymans · May 27, 2008

I am sure this is common but...

Take:

Code:

CheckID   Control
123       BR-1
123       BR-2
124       CT-3
125       AB-1
125       AB-2
125       FG-2

Turn it into:

Code:

CheckID   Control
123       BR-1, BR-2
124       CT-3
125       AB-1, AB-2, FG-2

Thanks. Sean.

Remou · May 27, 2008

The search term you want is 'concatenate'.

PHV · May 27, 2008

Have a look here:
faq701-4233

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