The tables that are available for the historical database display.
In the Table list, highlight the names of the tables that include the database items that you want to include in the query. For historical reports, you can select up to three table names.
In either the Database Items or Calculations box, highlight the first database item or calculation that you will reference in the query.
Select Add or double-click the item. The item is listed in the Query Items box.
Repeat Steps 6 and 7 until all of the database items and calculations that you believe will be referenced in the query are listed in the Query Items box.
In the Operand1 box, highlight the first database item or calculation that you want considered in the WHERE clause.
In the Operator box, highlight the appropriate operation.
In the Operand2 box, highlight the second database item or calculation that you want considered in the WHERE clause.
If you wanted 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.
Select AND or OR, as appropriate.
Repeat Steps 20 through 23 until you have completed the query.
Select Test.
CMS checks the syntax of the query and returns a message with any errors. For more information, see Appendix A: Error messages.
Correct any of the errors detected in the test.
Select Next.
A Query Assistant window is displayed. Use this window to give your query a new name.
In Name, enter the name that you want to assign to the query you created.
