Feedback

  • Contents
 

Summarize Query Data

Use the Results tab in a query tool window to summarize query results.

To summarize query results

  1. Create a Query or Open an Existing Query.

  2. In the toolbar, click Run. The results appear on the Results tab. The following example shows the Results tab in the Account Analysis window.

Account Analysis window - Results tab

  1. In the column heading, click the Sigma icon Sigma icon. The Select Summaries dialog box appears. The options available depend on the item's data type.

Select Summaries dialog box

  1. Select the calculations to perform on the data and then click OK. The result appears in the last row of the data grid. If you grouped data, the system calculates the data for each group and displays the results in the last row for each group.

Query results summary

Related Topics

Query Results