To define selection criteria

Choose the Criteria Tab. The Criteria window appears. Specify this information:
Index Select an index to base the query on. The associated key fields appear in the Index Key column.
Key Values

Specify values for the index keys to limit the query to the data that has those values. To add multiple key field values, separate values with a semicolon. To select a range of values, use -> to separate 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.
Conditions Select a condition to further limit the data that is searched.
Maximum primary records to return

Specify the number of records you want to display on the worksheet.

While the default is 600, you can enter a number up to a maximum of 65520 records. Specifying 0 (zero) also returns 65520 records.

Note: Remember that your worksheet may contain multiple lines for each record, you must not exceed the Excel limit of 65556 lines of data.
Maximum OTM values to return

Specify the number of one-to-many records you want to display on the worksheet. The maximum is 600.

Note: If your query includes selection criteria based on related fields, set this number high to ensure that all data matching your search criteria is returned. Note that the query may be slow, because more data must be processed to get complete results.