Find records that have an empty date field

[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

 

[Rick Brandt]

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????????????

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.

 

[aurora]

thank you for your help. I knew I was nearly right - just
couldn't figure out what I was doing wrong.

Aurora

 

[Terri]

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