Page History

Unless you add some sorting or grouping criteria to your query, the data you will receive will be a continuous list of records containing the fields you have requested, in the sequence in which it is stored in the primary file on the host. In some cases, this may be suitable for your purpose. In others, the data may be more useful if you sort it and, if suitable, add selection criteria to eliminate any unwanted data.
To specify selection and sorting criteria for a query, use these commands from the Options menu:

• Sort options, to specify the sequence.
• Field conditions, to specify the selection criteria.
• Group by, to split your data into groups.
• Summary options, to add totals.

...