Combine Rows and create fields

[carlos139]

I have a access table that contains multiple reccords per client. I want to combine each record based on the client into one row with separate field names.

Table below:

JobNbr, LineNbr, Desc, Product, Brand
1, 1, BAR, Mark5, Barcode
1, 2, SPR, Mark2, Sprint
1, 3, SPI,Mark4,Roll
2,1,BAR,Mark1, Barcode
2,2,SPR,Mark3,Valet
3,1,TAG,Mark7,Valet

Results:

JobNbr,LineNbr,Desc, Product, Brand, LineNbr2, Desc2, Product2, Brand2
1,1,Bar,Mark5,Barcode,2,SPR,Mark2,Sprint,3,SPI, Mark4,Roll
2,1,Bar,Mark1,Barcode,2,SPR,Mark3,Valet
3,1,Tag,Mark7,Valet

Thanks
Carlos

[NeoPa]

Pretty well impossible I'm afraid Carlos.
The closest thing I can think of to this (not an exact match) is Producing a List from Multiple Records

[carlos139]

How could I get this to work if I had more that two columns?

[NeoPa]

How could I get this to work if I had more that two columns?

The way you're looking to do it (from 1st post) would involve creating a formatted text field of the other fields and passing the resultant string into the function.
You would be better off using a different character to separate the fields than the function uses to separate the records though or it could be confusing.

[carlos139]

The way you're looking to do it (from 1st post) would involve creating a formatted text field of the other fields and passing the resultant string into the function.
You would be better off using a different character to separate the fields than the function uses to separate the records though or it could be confusing.

Neo,
I'm refering to your reply in post 2. The solution you refered to in that post only has a table with two columns. I tried that and can't seem to get more than two columns combined.

Thanks
Carlos

[NeoPa]

That's what I understood you to mean Carlos. That's why my answer reflects that. Have another read of it and if it still doesn't make sense to you then post back & I wiill try to fill in the details a bit more. It's very late for me now so I'm off to bed. I'll pick up any reply in the morning :)

[carlos139]

I don't understand can you shed some light on your thoughts.

[NeoPa]

I will try to do that for you Carlos but it may take a short while. I'm not around this evening either so, just in case I forget, bump this thread if you don't see anything from me by Friday.