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)
FROM TAB1
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?

Thanks!