Parentheses—Group Values
When using logical operators, you can use parentheses to group values. For example, to retrieve all projects with budgets less than $5,000 or between $15,000 and $20,000, enter the following expression in the Budget field:
<5000 or (>=15000 and <=20000)
For information on handling queries containing literal parentheses, see
Character String Qualifications (see page
Character String Qualifications).