Unique count in access

[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

 

[Luke M]

You might get more help by posting this question in the Access forum, as
opposed to this one (the Excel forum).

 

[Jacob Skaria]

Use the SQL query..

select distinct(id) from table1;

If this post helps click Yes

 

[Ashish Mathur]

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