Help with Date Range - Output

[tpearo]

I have a query in a training database that isn't working properly. I want to return data based upon a date range when an employee needs to be retrained in a procedure.

So I have a field that is an expression =
Expr1: [Date of Training]+365
This returns the date when the employee should be retrained annually.
But then on the criteria grid I want to view records between certain dates. So I have =
Between [Enter Begin Date] AND [Enter End Date]
The problem is that if I input the date range of 1/1/05 to 3/1/05 for example... the query returns all the proper records but also returns records for 10/05

Is there any way to fix this?

Thanks in advance.

 

[PHV]

Have you declared your parameters as DateTime ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244