Parameter Problem

N

NoviceIan

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
 
T

Tom Ellison

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
 
G

G. Vaught

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.
 
Top