Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Summarized By dropdown list.. Image of Summarized By dropdown list.. Image of Summarized By dropdown list.. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen. Image of Inquiry screen.

Summarizing a Query

Concept Link IconSee Also

After applying the query, the results are displayed, sorted by the default field in ascending order.

  • The initial summary level is NONE.
  • To summarize the data selected by a query, choose from the summary levels. The order of the fields in the query determines their level for summarizing.

Click on the picture for more information.

Image of Inquiry screen.

Click the Summarized By drop down list to show the available summary levels.

Image of Summarized By dropdown list.

Note: If [Budgets Available] appears after the summary level name then that field is included in the budget associated with the query.

Change the selected level to view the data at different summary levels. For example, summarizing on level one would group all items for one Fiscal Year into one line.

Level 1: Fiscal Year

The first summary level shows one line per Fiscal Year.

Click on the picture for more information.

Image of Inquiry screen.

Level 2: Fiscal Period

The second summary level shows one line per Fiscal Year-Fiscal Period.

Click on the picture for more information.

Image of Inquiry screen.

Summarizing on level three would expand the summary to show one line for each category by Fiscal Period for each Fiscal Year.

Note: NONE and last level show the same summary.

  • Click the Close button to close the result window and return to the main window.
  • Click the Print button to print the query in grid format.