Merge data from more than 1 row

[qwerty70]

Dear All,

In my Query1, I have the following data:

IsoLbl Comp2 Stencil
PBBCA-PR-16223.01 ELBOW GK14
PBBCA-PR-16223.01 ELBOW GK24
PBBCA-PR-16223.01 ELBOW GK50
PBBCA-PR-16223.01 ELBOW GK55
PBBCA-PR-16223.01 FLANGE GK27
PBBCA-PR-16223.01 FLANGE GK28

In the IsoLbl field as you can see there are 6 identical data. Under the Comp2 field there are 2 types of Iso Components which is the Elbow and the Flange. On the last field there are 4 different Stencils; GK14, GK24, GK50 & GK55. I want these 4 Stencils to be combined in one field since they fall under the same component of ELBOW....so forth and so on.

Report output should look like this:

IsoLbl Comp2 Stencil
PBBCA-PR-16223.01 ELBOW GK14,GK24,GK50,GK55
PBBCA-PR-16223.01 FLANGE GK27,GK28

I tried using the Grouping but no success.

Your help is highly appreciated.

Qwerty70

 

[PHV]

Have a look here:
faq701-4233

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

 

[qwerty70]

PHV, any clue how to call this function in Report please.

Thank you.

Qwerty70

 

[PHV]

What have you tried so far and where in YOUR code are you stuck ?

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