Date queries

[Sigurd]

I've agot a query that includes three date fields. Two of the date fields I wish to see the information that is entered or not. The third field should make the query include the records if this field does'nt contain information. This field is a discharge date field in the record. I'm wanting to look at records that don't have a discharge date. i know that I can't do a "Is Null" on a date field nor a " " to handle it either. Anyone have an idea?

 

[dneufarth]

Criteria of Is Not Null should work.


Dave

 

[Maquis]

Why can't you do an "Is null" on your date field?? I do it all the time. Maq B-)
<insert witty signature here>

 

[Mikey2000]

If &quot;Is Null&quot; doesn't work, perhaps there is a default value you can query for.