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
 

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

Back
Top