Query Group

The Query Designer form Group By section is only used when calculation fields are 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. 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.

   • Properties

   • Tables

   • Fields

   • Join

   • Filter

   • Order By

   • Group By

   • Having

   • Pivot Table

5. Determine what data element will be used to reset counters.

   Example: If you are listing activities for a staff member, you could add a Count field (Fields section) that would count activities for a particular staff member and the count would be reset to zero when the staff ID changed.

   Note: Only one record is displayed if a group is added, but no Count field is added. Counts will be unpredictable if the sort order and groups do not correspond.

 

Related Topics: 

• Query Limit Results