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).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"carrie" wrote:

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

Use the SQL query..

select distinct(id) from table1;

If this post helps click Yes
---------------
Jacob Skaria


"carrie" wrote:

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

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

"carrie" wrote in message
...
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