By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Combine Rows and create fields

P: 4
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
Oct 4 '07 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,487
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
Oct 5 '07 #2

P: 4
How could I get this to work if I had more that two columns?
Oct 9 '07 #3

NeoPa
Expert Mod 15k+
P: 31,487
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.
Oct 9 '07 #4

P: 4
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
Oct 9 '07 #5

NeoPa
Expert Mod 15k+
P: 31,487
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 :)
Oct 10 '07 #6

P: 4
I don't understand can you shed some light on your thoughts.
Oct 10 '07 #7

NeoPa
Expert Mod 15k+
P: 31,487
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.
Oct 10 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.