If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date query allowing user to enter dates
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 |
Thread Tools | |
Display Modes | |
|
|