Retrieve records except those containing Null 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 Not Null or Is Not Null. For example, to see a list of suppliers who have fax numbers from a table containing supplier information, type Not Null or Is Not Null in the Criteria cell of the Fax Number field.