Query where it only shows those with specific criteria in a cell (that criteria is being blank)

[CDobby]

I am very out of practice with Access
I have an existing table with numerous queries etc I have managed to add a new field to the table and forms. I now want to run some new reports but only showing certain data if criteria is specific, so assume I first have to run a query then maybe link that query to a report to print?

I cannot upload a portion of the table for you to see as the data is sensitive. Basically have a table that lists missing people with numerous columns for personal details, date of referral, last known address and other criteria to record. One column is to insert the date found. I want to run a report/query to show those that are still missing or do not have a date in the Date in the Found box (they are blank). I am in design view of the query and there is the Criteria. I tried typing in "" as the cell is blank (no date) but it didn't like it. How do I select data based on a cell being empty. Or have another cell to populate as Active if it is blank or Closed if it has a date in it.
Thanks.

[CCM]

try typing IsNull under Criteria.

[June7]

Actually, it would be Is Null - with a space.

[CDobby]

Thank you CCM and June7. Worked straightaway. I will slowly pick it up again. Many thanks. Chris

[June7]

Might find this of interest http://allenbrowne.com/casu-12.html