Retrieve records that don't contain values using a query

1. In query Design view, create a query. Add the tables whose records you want to use, and then add the fields you want to include in the results to the query design grid.
   
   
2. In the Criteria cell of the appropriate field, type the expression Is Null. For example, to see a list of suppliers who have fax numbers from a table containing supplier information, type Is Null in the Criteria cell of the Fax Number field.