Getting Query totals into a Report

[JRickman]

How does one get the Totals at the bottom of the query (Sum, Average, Count, etc.) directly into the Report?
I know I could export the query into Excel, import the Excel spreadsheet into a Table, and create a Report from the Table, but that seems a very round-about way of doing things.
Any help is appreciated.
Thanks, Jim

 

[John Big Booty]

Have a look at the various Domain Aggregation functions.

 

[JRickman]

I have no problems getting the Sum of a column of numbers in a Query. However, when I create a Report based on that Query, the Totals record at the bottom of the query does not appear in the Report. Is there a way to get that totals record at the bottom of the Query into the Report?
Many thanks, Jim

 

[JRickman]

I answered my own question. In the Report, right-click on the field, click on 'Total', and choose which operation you want to use. Very simple. In Layout view, you can adjust the width of the column if the resulting number is too large for the column width.