Re: Query criteria doesnt use year input
From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 05/29/04
- Next message: Van T. Dinh: "Re: Using IIF to return a zero value for a null"
- Previous message: Van T. Dinh: "Re: Query with multiple fields and one form"
- In reply to: Donna Brooks: "Query criteria doesnt use year input"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 29 May 2004 12:57:31 +1000
Perhaps you should post the full SQL String of the Query since the
parameters look OK.
--
HTH
Van T. Dinh
MVP (Access)
"Donna Brooks" <anonymous@discussions.microsoft.com> wrote in message
news:145bf01c444ea$cae68ec0$a601280a@phx.gbl...
> 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
>
>
- Next message: Van T. Dinh: "Re: Using IIF to return a zero value for a null"
- Previous message: Van T. Dinh: "Re: Query with multiple fields and one form"
- In reply to: Donna Brooks: "Query criteria doesnt use year input"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
