Summing values in report view

[BigBear]

Good Morning,

I need the syntax to sum the numbers indicated in the attachment in report view.. Just adding a sum function like =sum([Fee]) does not come up with the correct total because the fees are not stored for each record. They come from a separate table that was created to calculate the fees based on the user module and some other criteria.

I know there is a way to sum a group of numbers when the report is in report view, I just don't know what it is.

Thank you


L

[Harley Guy]

I am also having the same issue. I'm using Access for a Print Reduction project and I need to total the columns when I create a report by each department. The report runs from a query, I enter the department and it will list:
Report Name
Number of Times Run
Estimated Total Pages for Year
Estimated Total Reams for Year
Estimated Total Boxes for Year
Estimated Total Number of Trees Saved

There are a number of reports for each department and I need the totals for each Estimated Label. I use function =sum ([Estimated Total Pages for Year]), which I have in the Footer section and all I get is #error.

Please help!

[skocev]

Open you report in layout view and then select the colum. from the menu in Grouping&Totals select totals and then SUM. It will add a cell in wich it will colect the sum from records.

I hope that i help you.