Query Select Fields
The Query Designer form, Fields section allows you to add fields from the tables added to the query.
-
From the Tools menu, select the Queries... option.
The Queries form is displayed.
-
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.
-
Click the Fields tab.
The fields listed in Available Cross-Tab Fields are the selected fields from the Fields section.
-
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
orControl
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.
- Press Save to save the query.
- Close the Query Designer form, or continue to modify the query.