Passing a NULL value to a date field

[lman]

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

 
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

IIf([oper] Is Null, > 01/01/00, [oper])

but this doesn't display anything.

[TheShabz]

try:
IIf([oper] Is Null, > #01/01/00#, [oper])

or
Nz([oper], >#01/01/00#)

[lman]

Well unfortunately neither of those worked but i did find a solution, i noticed if you just put an * in the criteria access modifies it to Like "*" so i changed it to

Like [oper] and "*"

and it works perfectly

thanks for your help!