Search results

Thanks, that worked!

So I already have the lineNo What I need is; Pass1 InvoiceNo, ItemNo, LineNo---INTO--- InvoiceNo, ItemNo, Quanity 10100001, 11223, 1---------------------10100001, 11223, 2 10100001, 11223, 2---------------------10100001, 88923, 1 10100001, 88923, 3---------------------10100002, 45124, 1...

Semi good at access, always looking for answers

Actually, I do have all those tables. I have queried those tables and created Pass1. Now I want to run a series of queries to massage the data in Pass1 into a table (like combining identical itemNo that appear on the same invoice and adding a count) that will eventually be exported and sent to a...

Pass1 InvoiceNo, ItemNo, LineNo 10100001, 11223, 1 10100001, 11223, 2 10100001, 88923, 3 10100002, 45124, 1 10100003, 11223, 1 10100003, 11223, 2 10100003, 11223, 3 Thanks

OK, so I have a table called Pass1 In the tbl I have a field called InvoiceNo and a field called ItemNo and a field called LineNo. Explain: When a customer buys several items, each item is contained under the same InvoiceNo along with a unique LineNo. Example: A customer buys the same item...