N
No1momof3
HI
I have a DB where I am trying to set up a search criteria using 2 tables and
one field out of each.
Table - Services Field - Service
Table - Appointments Field - Appointment Date (format = dd/mm/yyyy)
How can I set up a query where the user can input to select appointments
between 2 dates ie: 01/04/2010 - 30/04/2010 and service (ie exams)
I notice when I do a filter it allows me to select the dates from the
calendar - can this be done in a search criteria and would I be able to make
the list of services available in a drop down box.
I am relatively new to DB and don't use it often so need easy instructions.
many thanks
Irene
I have a DB where I am trying to set up a search criteria using 2 tables and
one field out of each.
Table - Services Field - Service
Table - Appointments Field - Appointment Date (format = dd/mm/yyyy)
How can I set up a query where the user can input to select appointments
between 2 dates ie: 01/04/2010 - 30/04/2010 and service (ie exams)
I notice when I do a filter it allows me to select the dates from the
calendar - can this be done in a search criteria and would I be able to make
the list of services available in a drop down box.
I am relatively new to DB and don't use it often so need easy instructions.
many thanks
Irene