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 twice, along with a single item. In this case there would be 3 lineNo (1, 2, 3)
I want to generate a table that shows the InvoiceNo, ItemNo and count of how many times the same ItemNo appears for each InvoiceNo
Any help would be MUCH appreciated
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 twice, along with a single item. In this case there would be 3 lineNo (1, 2, 3)
I want to generate a table that shows the InvoiceNo, ItemNo and count of how many times the same ItemNo appears for each InvoiceNo
Any help would be MUCH appreciated
Last edited: