Boolean Operators

Boolean operators are functions used between filter expressions to refine the scope of your search or filter.

You can link two search terms, for example, Sales Rep equals Bill and Sales Territory equals Southwest, with these operators:

■ AND. Only records that contain both expressions are retrieved.

FilterSort condition used to select a subset of records from the entire database. includes only records where Sales Rep = Bill AND Sales Territory = Southwest. Both conditions must be true for the record to be included in the filter group.

■ OR. Any record that contains either expression is retrieved.

Filter includes all records where Sales Rep = Bill OR Sales Territory = Southwest. Either condition can be true for the record to be included in the filter group.