distinct count function

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?
 
C

ChrisJ

Try...

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