Parameter Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a query which displays all staff whos training will expire within a
period I enter into the criteria field. It works fine, however I want this
query to become a parameter query so that i can specify any period I would
like to see.

When i tried changing it to a parameter query it just showed all training.
Where am I going wrong?

Ian
 
Dear Ian:

Please open the SQL View of the query you have that is not working as
desired and post the text of the query you have there. Perhaps someone will
see what is wrong and help you correct it.

Tom Ellison
 
In the query under the field which contains the date of expiration enter:
Between [Enter Start Date] AND [Enter End Date] in the criteria area.
This will prompt you to enter a begin date and end date, which should return
any dates between that time period. If the dates entered are for the current
year, you only need to enter the month/day in each parameter box. If you
need for future years, then you must specify the year in the parameter box.
 
Back
Top