Test for unpopulated Date field

Glynn Taylor · Sep 9, 2005

I need to identify a short date field that has not had a date entered into it.
Tried creteria ="Nul" but this doesn't work.

Ofer · Sep 9, 2005

Try this

If isnull(creteria) then

End If

Erik · Sep 9, 2005

In the Criteria box, try typing: Is Null

or in the actual SQL, try:

WHERE (TheDateField Is Null)

Regards,
Erik