Query Limit Results

The Query Designer form Having section filters records from the results table (not to be confused with the Filter section). Typically it is not necessary to use the Having section.

  1. From the Tools menu, select the Queries... option.

    The Queries form is displayed.

  2. Select the module and record area, and either create a new query, or modify an existing query.

    Information on creating or modifying a query is available in Create New Query and Modify Query.

  3. Verify that Report is selected for Query Type(s) for the query.
  4. Click the Pivot Table tab.

    The fields listed in Available Cross-Tab Fields are the selected fields from the Fields section.

  5. Set criteria for specifying parameters of data in the results table of the query.

    The difference between the Filter and Having section is that the Filter section filters out data before it is included in the results table. The Having section filters out data that is included in the results table.

    Information on adding criteria is available in Query Filter.

 

Related Topics: