Finding null-blank dates

[Joseph Meehan]

I have a friend working with an Access database and and needs to query
just those dates that were blank when imported. She has tried null but it
gives a type mismatch as does "" and 0 etc.

Any ideas?

I believe she is working with Access 2002 and imported the data from a
text file from a mainframe download.

Thanks

 

[Allen Browne]

Assuming this is a Date/Time field in the table, she must use:
Is Null
and not a zero or zero-length string.

If she is applying the criteria to a calculate field, encourage her to
typecast the calculation with CVDate(). Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

 

[Joseph Meehan]

Assuming this is a Date/Time field in the table, she must use:
Is Null

That's what we both thought. I sent her your reply so we will see

Thanks.