>>>but i guess you want this:
>>>

>>>SELECT Visits.Patient_Name
>>>, count(DISTINCT Visits.Doctor_Name) AS Number_Of_Doctors,
>>>, count(DISTINCT Doctors.Doctor_Specialty)  AS Number_Of_Specialities
>>>FROM Doctors
>>>inner join Visits on Doctors.Doctor_Name = Visits.Doctor_Name
>>>GROUP BY Visits.Patient_Name;
>>>

>>
>>I think it would work. I don't have Access here at work, have to wait till I get home.
>>
>>Here are two more problems:
>>
>>Find which patients went to two or more doctors with the same specialty on the same day.
>>
>>Find which patients went to two or more doctors with different specialties on the same day.
>>
>>For these two queries we need to return the patient name, the date, the name of each doctor, and the doctor's specialty.
>
>

>>Find which patients went to two or more doctors with the same specialty on the same day.
>
>SELECT V.Patient_Name,V.Visit_Date,D.Doctor_Name,D.Doctor_Specialty
>FROM
>(SELECT Visits.Patient_Name,Visits.Visit_Date
>  FROM Doctors inner join Visits on Doctors.Doctor_Name = Visits.Doctor_Name
>	GROUP BY Visits.Patient_Name,Visits.Visit_Date
>	HAVING count(DISTINCT Visits.Doctor_Name)>=2
>           AND count(DISTINCT Doctors.Doctor_Specialty)=1) X
>  INNER JOIN  Visits V ON X.Patient_Name=V.Patient_Name AND X.Visit_Date=V.Visit_Date
>  INNER JOIN  Doctors D ON D.Doctor_Name = V.Doctor_Name
>
>>
>>Find which patients went to two or more doctors with different specialties on the same day.
>
>SELECT V.Patient_Name,V.Visit_Date,D.Doctor_Name,D.Doctor_Specialty
>FROM
>(SELECT Visits.Patient_Name,Visits.Visit_Date
>  FROM Doctors inner join Visits on Doctors.Doctor_Name = Visits.Doctor_Name
>	GROUP BY Visits.Patient_Name,Visits.Visit_Date
>	HAVING count(DISTINCT Visits.Doctor_Name)>=2
>           AND count(DISTINCT Doctors.Doctor_Specialty)>1) X
>  INNER JOIN  Visits V ON X.Patient_Name=V.Patient_Name AND X.Visit_Date=V.Visit_Date
>  INNER JOIN  Doctors D ON D.Doctor_Name = V.Doctor_Name
>

Thanks a lot, Fabio.