CountDistinct group function?

  • Thread starter Thread starter razor
  • Start date Start date
R

razor

Hi,

How can I write a query to Count the distinct values in a
field?

Is there an aggregate function called "CountDistinct()"
that I can use in the totals row?

Thanks!
Razor
 
No, not in Access.

To achieve the same effect, you need two queries -- one to select the
distinct values, and another to count them. In Access 2000 later, you can
make the first a subquery of the second, as in something like:

SELECT COUNT(*)
FROM
(SELECT DISTINCT
[Your Table].[Your Field]
FROM
[Your Table])
 

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

Similar Threads

wish there was a CountDistinct() function 6
how do i perform a Count(Distinct) query for 2 different column va 1
COUNT DISTINCT ? 5
DISTINCT option of an aggregate function in Access 2003 1
Count Duplicates Once 1
Opinion about aggregates 8
Access Dcount (multiple criteria) 3
Invalid use of null in query expression 3

Back
Top