Search results

I have a table like this in MS Access database: ID Date CustomerID InvoiceNo ItemNo Amount 1 01/01/2007 A 1 AAA 1 2 01/01/2007 A 1 BBB 2 3 01/01/2007 A 2 CCC 3 6 01/01/2007 B 5 AAA 6 7 01/01/2007 A 6 BBB 7 8 01/01/2007 B 5 BBB 8 I want to get disctinct count of InvoiceNo while summing up...