Query shows totals but report does not

[hazell]

Hi all,
I have created a very simple query to show the number of times a group runs in a qtr and also the total number of hours. In my query I can see both the count of times the group has run and the sum of the hours, but in the report that I have created from it, I can only see the count.
I used the sum function on the datasheet to display the totals.
What do I need to do to display the same information in the report?
Thanks

 

[stopher]

The sum function in datasheet view is only visible in datasheet view. You need to do your summing in the report itself. Reports are very good at summing by group or over the whole report.

Here's a reasonable explanation:
https://www.techonthenet.com/access/reports/group_footer1.php

 

[RogerCooper]

You may not need a report. You can use "Printout" to print the query directly in a Macro or VBA.