Deselect Field

S

Sam

I have a query with one field criteria set at "not blank" and this works
fine. I have a date field that I want to show only if there is NO date. I
can't get this to work. I can show only data with a date but not all data
with no date. Help, please?
Thanks!
 
J

John Spencer (MVP)

The criteria for that is "Is Null"

Field: SomeDateField
Criteria: Is Null

Use Is Not Null to get all the date fields that do have a value.
 
Top