Unexplained Query Results

[smaumau]

Below I have listed the WHERE clause of my query. For this example, the start date and end date mentioned are 4/1/08 and 4/15/08 respectively. I am getting results that are between 4/1 and 4/15, but for different years. The odd thing about this is that this query has worked fine for several years and now it is giving me strange results. Does anyone have any thoughts?

WHERE [salesdate1] Between [Forms]![frmflash]![StartDate] and [Forms]![frmflash]![EndDate] and [Division] like [Forms]![frmFlash]![Division] and [transfer?1] = no

Thanks.

 

[odin1701]

What is the field in the data table for the dates formatted as?

If it's not stored, what is the format of the text box on the form?

Also what is the format of salesdate1 in the data table?

 

[smaumau]

Thank you!

I missed the most logical explanation. The formats got changed after some table exporting/importing.

Thanks again.

 

[odin1701]

I've been there too. We often overlook the simple stuff.