NOT

This function inverts the recordset that is created by the expression argument. The resulting recordset will not contain any of the records that matched the original expression.

It is equivalent to clicking the "Invert the current selection" button within the Selection window.

NOT ( <expression> )

  • expression: A query string that defines a recordset.

Example: consider the following query that selects female individuals with an income over 0.

([Individual.Gender Bands] = "Female") AND ([Individual.Income] > "0" )

Using NOT you can invert the recordset to show all customers who do not match this criterion.

NOT(([Individual.Gender Bands] = "Female") AND ([Individual.Income] > "0")