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.
|