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)
 
Back
Top