I'm stuck. I use Access 2000. I have a date field in a query.
What I need done is if a Limit_Date function returns a true, I want
the date field to be Between 1/1/02 and 1/1/03, otherwise I want it
left alone(all records shown).

I have an if statement in the criteria:
iif(Limit_Date()=true,Between 1/1/02 and 1/1/03,"*")
This does not work since the if statement returns strings. So if
Limit_Date is true, then the criteria is "Between 1/1/02 and 1/1/03".
If its false then I get a *, which won't work with out a Like
statement.

Is there a way I can make a Between statement that accepts all dates?
I tried doing Between * and * but it does not work. I was hoping to
put if statements in the *, so if Limit_Date is true, the if would
return a date else "*".

Please help.

Thanks in advance.

Enterprise wrote:
wouldn't have to worry about it again until the year 2040. Have you
tried using null in your iif statement, iif(Limit_Date()=true,Between
1/1/02 and 1/1/03,null).