I really need some help with the following problem if anyone would be
willing.
I need a list box to list the opposite of what appears in a query.
Heres the details:
My database is for a doctors surgery, and this includes the tables
tblPatients, tblDoctors and tblAppointments. tblAppointments has an
Appointment ID and also includes the Patient ID (from tblPatient) and
Doctor ID (from tblDoctor) plus the start and end time of the
appointment.
tblAppointment(APPOINTMENT_ID, patient ID, Doctor ID, start time, end
time)
What I want to do is create a list box that lists all the Doctor ID's
for doctors who do not have an appointment at a given time. this time
is determined when the user types in a start and end time on a form. I
have created a query which lists all the Doctor ID's that do have an
appointment at that time. this query is based on the tblAppointment.
what I now want to do is create a list box that will list all the
Doctor ID's that do not appear in this query.
Sounds pretty basic stuff I know, but I've been trying for days with
NOT arguments and many other methods, but had no success.