Find records that have an empty date field

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I want to search for open records - that is records where
the "closed date" field is empty. I tried a criteria
of "IsNull" in the closed date field but this did not seem
to work. Told me I have a mismatched field. Does anyone
know how to do this????????????

Help.

Aurora
 
Aurora said:
I am using Access 2000

I want to search for open records - that is records where
the "closed date" field is empty. I tried a criteria
of "IsNull" in the closed date field but this did not seem
to work. Told me I have a mismatched field. Does anyone
know how to do this????????????
Click to expand...

Two words Is Null.

IsNull() is a VBA function that performs a similar test, but it is usually not
required in a query since Access SQL is capable of testing for Null on its own.
 
thank you for your help. I knew I was nearly right - just
couldn't figure out what I was doing wrong.

Aurora
 
I think the problem is that you need a space between Is
and Null. I am using '97 but it works on mine.
 
Back
Top