Hello,
I have posted under forms but this could relate to the queries section.
I am trying to use an appointments database which I discovered via this forum (http://members.shaw.ca/glenk/access2000.html). It has a calendar. On selecting a date on the calendar, appointments are shown for that date for all practiioners.
What I would like is the appointments for a given practiioners to be shown. I thought I could enter a parameter asking for the sales practiioners id. If I do this this I receive errors saying the query is to complex.
The current SQL is:
SELECT Appointments.ApptsID, Appointments.Date, Appointments.Time, PatientDetails.Name, PatientDetails.DOB, PatientDetails.Address, PatientDetails.NI, PatientDetails.Address2, Appointments.PatientID, PatientDetails.Tel1, Appointments.PracticionerID, Appointments.HomeVisit, Appointments.Receptionist
FROM PatientDetails INNER JOIN (Practicioners INNER JOIN Appointments ON Practicioners.PracticionerID = Appointments.PracticionerID) ON PatientDetails.PatientID = Appointments.PatientID
WHERE (((Appointments.Date)=[Forms]![ApointmentsFinder]![Cal1].[Value]))
ORDER BY Appointments.Date, Appointments.Time;
Any guidance would be appreciated.
Thank you.
Adam
Access 2000
I have posted under forms but this could relate to the queries section.
I am trying to use an appointments database which I discovered via this forum (http://members.shaw.ca/glenk/access2000.html). It has a calendar. On selecting a date on the calendar, appointments are shown for that date for all practiioners.
What I would like is the appointments for a given practiioners to be shown. I thought I could enter a parameter asking for the sales practiioners id. If I do this this I receive errors saying the query is to complex.
The current SQL is:
SELECT Appointments.ApptsID, Appointments.Date, Appointments.Time, PatientDetails.Name, PatientDetails.DOB, PatientDetails.Address, PatientDetails.NI, PatientDetails.Address2, Appointments.PatientID, PatientDetails.Tel1, Appointments.PracticionerID, Appointments.HomeVisit, Appointments.Receptionist
FROM PatientDetails INNER JOIN (Practicioners INNER JOIN Appointments ON Practicioners.PracticionerID = Appointments.PracticionerID) ON PatientDetails.PatientID = Appointments.PatientID
WHERE (((Appointments.Date)=[Forms]![ApointmentsFinder]![Cal1].[Value]))
ORDER BY Appointments.Date, Appointments.Time;
Any guidance would be appreciated.
Thank you.
Adam
Access 2000
