Unique Count

[carrie]

I am trying to do a unique count in access. If I have the below loads in a
table:
ld number
236592
236592
2010968
2010951
I want to count the unique records which would be 3. If I use the Count(*)
function I get 4. Can I do this with out creating multiple queries?
thanks,

 

[Jerry Whittle]

Select Count([ld number])
FROM (Select Distinct [ld number]
From TheTable Name) ;