Unique count in access

  • Thread starter Thread starter carrie
  • Start date Start date
C

carrie

Is there a way to do a unique count in Access? For instance if I have the
following loads in a table:
236592
236592
2010968
2010951
I can use the Count(*) function but I will get 4 lds. I want to get 3 loads.
Appreciate any help.
Thanks,
Carrie
 
You might get more help by posting this question in the Access forum, as
opposed to this one (the Excel forum).
 
Hi,

Use this

select count(uniquesa) as "Distinct values" from
(
select distinct numbers as [uniquesa] from <your table>
)

Numbers is the column heading.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top