I've created a simple select query in Microsoft Access wherein I'm searching all records based on the "Final Payment Due Date". The Final Payment Due Date is a calculated expression based on two other fields.
In the criteria for the calculated expression I've entered "Between [Enter Start Date] and [Enter End Date]" so that the user can return all reservations for which final payment is due for the entered period of time.
For some bizarre reason, if the user enters, for instance 9/1/06 as the start date and 9/30/06 as the end date, the results include all reservations for which final payment was due between 9/1 and 9/30, but for all years (it's including final payments due between 9/1/05 and 9/30/05 as well). It's like the query isn't registering the year that is entered. Can anyone tell me why this is happening... or better yet, how to fix it? Thanks!
In the criteria for the calculated expression I've entered "Between [Enter Start Date] and [Enter End Date]" so that the user can return all reservations for which final payment is due for the entered period of time.
For some bizarre reason, if the user enters, for instance 9/1/06 as the start date and 9/30/06 as the end date, the results include all reservations for which final payment was due between 9/1 and 9/30, but for all years (it's including final payments due between 9/1/05 and 9/30/05 as well). It's like the query isn't registering the year that is entered. Can anyone tell me why this is happening... or better yet, how to fix it? Thanks!