Boolean operators and parenthetical grouping are used to create queries with two or more search criteria.
The Query Builder tab is the primary query environment. Unlike the Quick Query and Range Query tabs, the Query Builder can be used to create queries based on multiple criteria. You can also parenthetically group criteria and specify what fields are displayed and how they are sorted when the query is returned in the Data View window.
The Query Builder tab introduces Boolean operators and parenthetical grouping, which are used to create compound queries based on two or more search criteria. For example, using Boolean operators, you can generate a query that returns a list of all light fixtures of a given type that were installed after a specific date.
(All rooms that are offices and are currently unoccupied)
(All rooms that are cubicles and are currently unoccupied)
This query returns a list of all unoccupied offices and cubicles.
You can nest up to four sets of parentheses within a statement.