Selecting all records that do not match a value in a selected field

  1. Select a value that you want to exclude from the search.
  2. From the Record menu in the Attribute Manager, click Query by and then click Excluding Current.

Query by Example:

You can create an expression that selects all corresponding records. An expression can be a statement where two attributes are connected by a relational operator to produce a result. It can also be two or more statements joined by an AND or OR operator.

For example, if you have an attribute called Length that describes the length of rivers on a layer, you can query 'Length > 10.' The result shows all records that contain a value greater than 10 in the Length field.

Parent topic: Selecting all records that match a value in the current cell
Next topic: Making a query by example

© PCI Geomatics Enterprises, Inc.®, 2026. All rights reserved.