Columns of unlike values to a Single row (not your usual transform!)

[kq]

I have been unable to find any way to "transform" rows of information to a single line where the values I need to "transform" are unique to the value of the row! I'm also pretty bad at explaining this! So let me draw a picture...

FIRMA ABC
FIRMA DEF
FIRMA GHI

FIRMB JKL

FIRMC STU
FIRMC VWX

And I need to see this as

FIRMA ABC/DEF/GHI
FIRMB JKL
FIRMC STU/VWX

The "FIRMS" will change every month as well the CODES so I can't hard code the firm values.

Can ANYONE HELP?????

 

[kq]

Oooh! Just saw the post immediately below mine -- exactly the same question! Sorry!

 

[cmmrfrds]

I took a stab at it in thread701-341667 but I have not heard anything back.

If the recordset if not too large to be done on the client side, I think I can help you come up with a solution.