0 -00Eric Clapton Sep 6, 2005 #1 Hi, How do I do a distinctive count on a query using group-by option in Access 97? Thanks.
M Michel Walsh Oct 11, 2005 #2 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
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
