PC Review


Reply
Thread Tools Rate Thread

Date query allowing user to enter dates

 
 
No1momof3
Guest
Posts: n/a
 
      7th May 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to create a date range in a query where user picks dates . . =?Utf-8?B?S2FyZW4=?= Microsoft Access Forms 1 21st Jun 2007 11:35 PM
End User to Enter Date in Query RickinRSM Microsoft Access Queries 0 23rd Sep 2006 04:03 AM
Query using 'Between [Enter Start Date] And [Enter End date]' =?Utf-8?B?Z29waQ==?= Microsoft Access 4 24th Mar 2006 01:58 PM
Allowing user to enter value for listbox =?Utf-8?B?QWxjaWRl?= Microsoft Word Document Management 2 29th Jun 2004 05:06 PM
Show all dates if user does not enter a date range Sierras Microsoft Access Forms 4 22nd Jun 2004 03:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:25 PM.