-
And/Or: All criteria statements are added as OR criteria. Select a second statement and click AND to make both criteria required.
- Parentheses: Complex queries might require that you use parentheses. Values in parentheses are evaluated first by the database; for example:
Class equals 1964
AND Major equals biology
AND (Home State equals WY
OR Home State equals IL)
In this example, the Home State condition will be evaluated before Class and Major are evaluated.
To use the parentheses, click the line where you want to start the parentheses and click the left parenthesis tool. Repeat for the right parenthesis.
-
Change: Select a line and click Change to reopen the dialog box where you chose the specific condition (such as the specific state).
-
Remove: Select a line (a condition) you want to remove and click Remove.