Defining Selection Criteria for an Application Query

Note: The options on the Criteria tab for an application query are different from those for a database query.

To avoid returning long lists of data you don't want, set up criteria that defines the range of data from selected fields that displays on the worksheet. All steps in this procedure are performed on the Criteria tab.

To define selection settings

  1. In the Maximum # of Records to Return field, specify the number of records you want to display on the worksheet. The default is 10.
  2. In the Value column under Key Field Settings, specify a value for the key fields to limit the query to the data associated with that value.

    To clear a key value from the screen, click Clear Key Values.

    Note: You can use key values for as many index keys as you like. However, if you skip a key value field, the wizard won't read past the field you skipped.
  3. In the Values column under Set Field Filter Values, specify a value for a field to limit the query to the data associated with that record.

    To clear a field filter value from the screen, click Clear Filter Values.

  4. Click Next to proceed to the Subtotals tab.