> if you want to count the distinct occurances from the table listings, you
> need to create a query that selects the distinct values then then second
> query which selects the count from the first query.
>
> COUNT(DISTINCT... is incorrect syntax.

The SQL is correct, Access doesn't seem to cope well with COUNT (DISTINCT
column) though.

Regards,

Morten Wittrock
Copenhagen, Denmark