SELECT COUNT(DISTINCT field) ?

[Leo Karl]

In learning SQL from somewhat older manuals, I find the useful SELECT COUNT
(DISTINCT field) statement. I think I understand workarounds, but I would
like to understand why it doesn't work in MS Access 2002, or, am I missing
something?

 

[John Vinson]

I think I understand workarounds, but I would
like to understand why it doesn't work in MS Access 2002

Because the Microsoft programmers who developed Access chose not to
implement it.

Why they made that choice I don't know, but they didn't.