I have an Access database with a date field - this does not have to be present. How do I test for null date??
Printable View
I have an Access database with a date field - this does not have to be present. How do I test for null date??
All you have to do is something like this:
orCode:'Looking at it in a form field of some kind.
if MyField = "" then
msgbox "It's Empty"
else
msgbox "It's not empty"
endif
That's all there is to it.Code:'Looking at it in a query using sql
Select * from MyTable where MyField = Null;
if not isdate