Grand total in report

[5556]

I have a number of text boxes with values in them in the detail section of my report. How can I get a grand total of all the rows of the report at the bottom of the report?

 

[wtmckown]

In a footer section (report footer if you don't need any group totals) you can add text boxes that work in one of two ways. For totaling columns that are based on recordsource fields you simply set the total control source to '=sum(FieldName). If columns are calculated values then you need to create invisible copies of them (with running totals set) in your detail section and refer to them in the control source of your associated total text boxes in the footer section.