Troubleshooting guide

February 2006 129
9. In the Operand2 box, highlight the second database item or calculation that you want
considered in the WHERE clause.
Example: If you want the report to select the data from the table when the number of
ACDCALLS is greater than the number of ACWINCALLS, you would select acdcalls in
the Operand1 box, the > sign in the Operator box, and ACWINCALLS in the
Operand2 box.
10. Select AND or OR, as appropriate.
11. Repeat Steps 7 through 10 until you have completed the query.
You can add your own text in the WHERE clause, such as parenthesis and numbers,
by placing your cursor where you want the text to display and enter in the text.
12. Select Test.
CMS checks the syntax of the query and returns a message with any errors.
13. Correct any of the errors detected in the test.
14. Select Save.
The changes to the query are saved and the Query Select window is displayed.