Deselect Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top