Query criteria doesnt use year input

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.


-----Original Message-----
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


.

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.


--
Ken Snell
MS ACCESS MVP

"Donna Brooks" wrote in message
...
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

Perhaps you should post the full SQL String of the Query since the
parameters look OK.

--
HTH
Van T. Dinh
MVP (Access)





"Donna Brooks" wrote in message
...
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