I'm sure the answer to this is simple, but i can't see the wood for the trees.
I have several fields in an access query that i am passing parameters values to through VBA. I use the following statement in the criteria field of the query to check if the value passed is null
Code:
IIf([oper] Is Null,"*",[oper])
[oper] is the parameter, and if null it displays all the records ("*").
This works fine expect for a field that has a date/time data type. (data type mismatch). I have tried something like
Code:
IIf([oper] Is Null, > 01/01/00, [oper])
but this doesn't display anything.