Test for unpopulated Date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
In the Criteria box, try typing: Is Null

or in the actual SQL, try:

WHERE (TheDateField Is Null)


Regards,
Erik
 
Back
Top