P
Pete
I have a query that includes a date field in its output. I have a check box
on a form where the user can choose whether to include blank (null) dates or
not in the output. If they tick the box nulls should be included. However I
cannot get the following criteria expression to work.
IIf([Forms]![myForm]!![chkBlank]=0,Is Not Null,True)
on a form where the user can choose whether to include blank (null) dates or
not in the output. If they tick the box nulls should be included. However I
cannot get the following criteria expression to work.
IIf([Forms]![myForm]!![chkBlank]=0,Is Not Null,True)