Totalling fotter amount in report footer

[disgruntled]

Hello there.....I have a report that I am trying to alter. There is a detail section and two footer sections. I would like to insert into the report footer a "total" textbox where the sum of a value in one of the footer sections is shown. The name of the field in the footer is "Region_Total". I tried making the control source of my new report footer field =Sum([Region_Total]) but to no avail....

My detail has data about values in Districts which are in Regions. Therefore, we have a footer that sums the values in each region and in each district seperatly.

Therefore the sum of either of these totals should equal one another. This is the value I am trying to capture.

 

[cpod]

You have to total the field from you detail section. If the field you are totaling is say "Sales", then in the regional footer you have a textbox with:

=Sum([sales])

Now, to get a grand total, you add a report footer and a textbox with:

=Sum([sales])

 

[jasonx]

Or, if your sales total is a calculated field, use running sum to create another field, then sum this new running sum field. It should give you a correct grand total or subtotal.