>try this simple command, before:
>
>SELECT patient_name,count(DISTINCT Doctor_Name) as num from Visits
>
>
The same missing operator error. I'm using Access 2000. Looks like count(distinct ... ) is not allowed in Access database.
If it's not broken, fix it until it is.
My Blog