To create a criterion

  1. Double-click or drag a schema or statement to add it to the Table Diagram tab.

  2. Right-click a column in the graphic design area of the screen and select Add Criterion. The Specify Criterion Wizard appears. You can also right-click in the Criteria Logic tab and select Add Criterion.

  3. Select the column, SQL function, parameter, or constant you want to start the criterion with and click the Next button. Your selection appears in the field at the bottom of the wizard.

  4. Continue making selections from the wizard and follow its instructions until you complete the criterion and the Finish button appears.

  5. Click the Finish button to add the criterion to the current statement.

For more information on criteria, see the Building Criteria and Building Expressions sections.