You can use the Edit Criteria Properties page to define your criteria.

 

There are two methods to define criteria:

 

1. Creating criteria based on a field.

     If you access the Edit Criteria Properties page by clicking the Add Criteria icon on the Fields page, the Edit Criteria Properties page appears with the selected field populated in the Expression 1 field. You specify the criteria for the field and click OK to return to the Fields page.

 

2. Creating criteria not based on a field.

     If you access the Edit Criteria Properties page by clicking the Add Criteria button on the Criteria page, the Edit Criteria Properties page appears enabling you to edit Expression 1 and Expression 2 fields. Select the Field or Expression option, and edit the second Expression column to enter comparison values.

 

Query Manager enables you to add criteria to a query in multiple ways:

• Click the Use as Criteria icon on the Query page.

• Click the Add Criteria icon on the Fields page.

• Click the Add Criteria icon on the Expressions page.

 

In this topic, you will define criteria.


Table of Contents