SELECT COUNT(DISTINCT field) ?

  • Thread starter Thread starter Leo Karl
  • Start date Start date
L

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?
 
I think I understand workarounds, but I would
like to understand why it doesn't work in MS Access 2002
Click to expand...

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.
 
Back
Top