distinct count function

  • Thread starter Thread starter Natasha
  • Start date Start date
N

Natasha

Hi,

I am trying to find out how to count unique account
numbers in a sales invoice table.

can any one shed some light on it for me?
 
Try...

SELECT Count([AccNum]) AS Expr1
FROM (select distinct [AccNum] from tblAccounts)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distinct Record Counts 6
COUNT and DISTINCT in Access 3
Totals Query with Multiple Counts 3
distinct DCount - so close! or so close? 2
Distinct count for each day 2
Create a distinct Join 3
Distinct Count 5
Unique Count 1

Back
Top