Retrieve records that don't match a value 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, enter an expression using the Not operator. For example, you can type the expression Not T* in the Criteria cell of the CompanyName field to find all customers whose names don't begin with T, or Not 2 in the ShipID field to find shippers whose ID isn't 2.