Query Filter Expression

[cruzpatas]

I have a Form that is set to filter a query by dates. The code in the query linking the two is as follows - Between [forms]![frmConfirmation]![txtbd] And [forms]![frmConfirmation]![txted] - bd = before date & ad = after date ex. bd (4/1/2006) - ad (4/30/2006). It has been working great, until now. It is currently giving an error when I enter the dates that I want to view, but only the months from April on. Jan - March still works great. The error states, "The expression is typed incorrectly or too complex to be evaluated. Expression may contain too many complicated elements."
This can not be, because it works for 3/1/2006 - 3/31/2006 and before, but not 4/1/2006 - 4/30/2006 or any month thereafter. Anyone have an idea.

 

[pbaldy]

Sounds like a data issue. Check the data for April and see if there's any crazy stuff, particularly in that field.

 

[cruzpatas]

I thought the same thing, but can't find anything to be different than the months before. I am going to check again. thanks Chris