Yeah, I kinda mis-read what you wanted

Anyways, from what I can find, your original query looks correct, but I guess if it isn't supported by Acc2000, you'll have to find another way.

The group won't help directly, but doing something like this may:
Code:
SELECT DISTINCT field INTO temp_table FROM mytable;
SELECT count(*) FROM temp_table;
DROP TABLE temp_table;
I "stole" the idea from here which stemed from here .

I don't have Acc2000 here, so you're on your own for now.