Hello,
I have a table with the following fields:
Invoice
Division
Amount
The Invoice can repeat (and often does) as each invoice can have multiple divisions. Divisions can also repeat for a single invoice as separate records have different Amounts.
What I need is a query that will tell me...