Query Select Fields

The Query Designer form, Fields section allows you to add fields from the tables added to the query.

  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. Click the Fields tab.

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

  4. To add a field, highlight the available field name in the left box, then double-click or press , and the field will be added to the query.

    Tip: You can select multiple fields by using either the Shift or Control keys.

    Note: Cnt, Sum, Avg, Max, Min, and certain Other... fields are all calculated fields. If a calculated field is added to the query, you must add a “reset” point for the calculation in the Group By section, or the result table will include only one record because there is only a single calculated field result.

  5. Press Save to save the query.
  6. Close the Query Designer form, or continue to modify the query.