Select rows that do not match a value in a query (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

To find rows that do not match a value, use the NOT operator. For example, to find all the rows in a products table where the values in the product code column begin with a character other than "A," you can enter a search condition such as the following:

NOT LIKE 'A%'