First off I would like to say HI as I just joined this forum. I do a lot of reporting at work using MS SQL and MS Access. I just ran into a problem today with some of my MS Access queries and I was hoping you guys might be able to help me.
I have a MS Access DB that is a front end for data that lives on a MS SQL server. I have users doing reporting for Helpdesk tickets. When they run the queries they get presented with a date box to fill in the start date and the end date using this format: Between [Type begin date MM/DD/YYYY] And [Type end date MM/DD/YYYY]
This worked great all year until today. Now they want to bring back information from last year and this year. When they run the query it returns all records for last year. The part that is confusing me is if I take the between statement and hard code the dates its works fine. Example: Between 10/01/2004 And 01/03/2005. But the minute I put it back to the between pop up box it returns everything. I have checked the regional settings in windows also and they are fine.