distinctive count

  • Thread starter Thread starter -00Eric Clapton
  • Start date Start date
0

-00Eric Clapton

Hi,

How do I do a distinctive count on a query using group-by option
in Access 97? Thanks.
 
Hi,

You can try with a crosstab.


TRANSFORM COUNT(*) as theValue
SELECT theGroup,
COUNT(*) as totalCount,
COUNT(theValue) As distinctCount
FROM myTable
GROUP BY theGroup
PIVOT theCountedField IN(null)



Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

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

perform INNER JOIN on query results 2
Access MS Access Help with Select Distinct(count field) 0
how do i perform a Count(Distinct) query for 2 different column va 1
calulated field on main after filtering subform 1
Combo is null 4
COUNT and DISTINCT in Access 3
Select disintct I need to order by on a field not in the select 1
Need help cascading 5 combo boxes 12

Back
Top