Hi,
I'm using a query that has 6 possible parameters for filtering. One of the filters is a date range with start and ending dates. The date range works fine by itself or when other parameters have values. But if the user enters a value into another control (parameter) and leaves the date range blank the query finds 0 records. Here is my experience with the criteria I have tried.
1. Between [Forms]![Send Letter]![StartDate] And [Forms]![Send Letter]![EndingDate] THIS WORKS
2. Like "*" & [Forms]![Send Letter]![StartDate] & "*"- JUST ENTERING THE START DATE AS AN "EQUALS THE DATE" and THAT WORKS
3. Between Like "*" & [Forms]![Send Letter]![StartDate] & "*" And Like "*" & [Forms]![Send Letter]![EndingDate] & "*"
BUT THAT TELLS ME I MAY BE MISSING A COMMA when I try to save the query.
Any thoughts. I can't do VBA and I believe some variation of this should work.
Jeff