embarrassing question - how to find records with blank Date?

[hollifd]

I have a table with a field called ActualEndDate and it is defined as a Date/Time field with a format of ShortDate. I want a simple query to show me only the records where this field is not filled in. I cannot get any query to only show me the records that are not filled in. What could I be doing wrong? What is the "criteria" to only show records where this field is empty?

Thanks,

David

 

[Norie]

David

What have you tried?

Did you try IsNull for the criteria?

 

[hollifd]

Norie,

I have tried:

IsNull
Null
IsMissing
IsEmpty
""

Can you find blank Date fields on your system with any of the above? I am wondering if maybe something is wrong with my system. I am going to reboot to see if that might help.

Thanks,

David

 

[Norie]

David

Is Null works for me.

How exactly are you using the criteria?

 

[hollifd]

Norie,

I rebooted and is working now. I should have tried that first since my system did not seem to be behaving properly.

Thanks,

David