IIF syntax, if null return all problem
Posted on 2008-10-06
MS Access 2003
I need help with my syntax.
IIF([district1] is null, like "*" or NZ([district]), [district1])
This is my criteria, [district1] is undefined and gives a msgbox(think thats the term, pops up asking for a value).
[district] is the field for which i am trying to establish a criteria.
What i want is to return all lines unfiltered when nothing is typed into the msgbox.
what i get is this "this expression is typed incorrectly or is toocomplex to be evaluated...."
can you help please.
I'd prefer not to do this in vb but can if needed