Query criteria doesnt use year input

  • Thread starter Thread starter Donna Brooks
  • Start date Start date
D

Donna Brooks

I have created a query in my HR database to pull all
employees due for their 90 day evaluation. Fields are as
follows: EmpNo
LastName
FirstName
HireDate
90Days: DateAdd("d",90,[HireDate])
I can run the query, calculates great. But, I need to
pull all employees, for examples, that the 90 Day is due
between 06/01/2004 and 06/30/2004, so in the criteria for
this expression, I use:
Between [Enter the first day of the month] and
[Enter the last day of the month]
It runs the query, but it pulls all employees with 90 Day
due in June regardless of the year. I need it to only
pull the ones with the year I specify. For example, I get
results like this, if my criteria were between 06/01/2004
and 06/30/2004.

525 John Doe 03/05/04 06/05/04
480 Jane Doe 03/08/01 06/08/01
592 Joe Blo 03/11/02 06/11/02

The only one that I need it to pull would be the first
one, the one in 2004.

Please help.
Thanks,
Donna Brooks
 
First create a query that uses the datePart function to
extract the year and use 2004 in the criteria. Then use
your DateAdd query and base it on the datePart query. I
realize this is only a temporary fix as it will eventually
be 2005. but it should work for a little while at least.
 
Why not change your "parameter" prompts to these:

[Enter the starting date of the 90-day window:]

[Enter the ending date of the 90-day window:]


And then, when the parameter window is displayed, type in a full date:
6/1/2004.
 
Perhaps you should post the full SQL String of the Query since the
parameters look OK.
 
Back
Top