Search results

PatHartman, That's exactly what my final query does. My question is: is there any other way of doing it? My other question is: Why the correlated query doesn't give the right count as it does in other DB? Cheers Huyeote

GohDiamond, Thank you for your reply. But the right count of unique invoice no is 3 though there were 4 records for Customer A on 1/01/2007. What I'm looking for is the count of unique/distinct records in a field. Huyeote

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...