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:
I "stole" the idea from here which stemed from here .Code:SELECT DISTINCT field INTO temp_table FROM mytable; SELECT count(*) FROM temp_table; DROP TABLE temp_table;
I don't have Acc2000 here, so you're on your own for now.