Thread: Count function in MS Access
12-18-02, 04:26 #1Registered User
- Join Date
- Oct 2002
Unanswered: Count function in MS Access
When I used Count () function to count distinct rows, I got the error for the syntax of this Count expression.
Here is the query:
SELECT ColA, COUNT(DISTINCT ColB)
GROUP BY ColA
I issued the above query in DB2 and there is no error. Anyone has any idea why Access complains expression syntax of the above query?