Blank date field

[kidzmom3]

I have a date field in which some records are blank. I want to query those blank records, but I keep getting a "data type mismatch in criteria". I have tried IsNull, "", ##. Nothing is working! HELP!

[This message has been edited by kidzmom3 (edited 01-30-2002).]

 

[paris]

Did you try Is Null? I had a similar problem last week. I was just using Null with no success.

 

[kidzmom3]

Thx Paris, but I have tried that and it puts quote around the IsNull and then gives me that data type error. I dont't want to use IsNotNull because I want to view all the Null date records. Any other suggestions?

 

[Rich]

There is a space between Is and Null in sql
ie Is Null

 

[kidzmom3]

Thx a Bunch!!! It worked!!!!