I need to have a query return results where one field is a date (not an issue) and another field is blank. What criteria do I set for the blank field?

Thanks for the help,
Bonnie

Is Null

Thanks!

or use the expression

Trim$(Nz([field],"")) <> ""

which also works correctly for strings that are blank but not null.