By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,727 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,727 IT Pros & Developers. It's quick & easy.

Select Query Using Calculated Expression and Date Search

P: 1
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!
Sep 6 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.