Totalling a total column

[James]

i have set up a total column in a report to add across the rows in the main
part of the report and in the footer of the same report i would like to total
these numbers. Is there a way i can do this.

Data 1 | Data 2| Data 3| Total
1 | 2 | 4 | 7
2 | 1 | 6 | 9
7 | 4 | 3 | 14
__________________________
10 | 7 | 13 | This number i cannot get

 

[Rob Parker]

Hi James,

You don't say how you've "set up a total column", so I can;t be sure this
will work. But assuming that your textbox control for the toal in each row
in the detail section contains an expression such as "= [Data 1] + [Data 2]
+ [Data 3]", and that your totals boxes in the footer contain expressions
such as "= Sum([Data 1])", you can do it by entering "=Sum([Data 1] + [Data
2] + [Data 3])" in the grand-total textbox.

HTH,

Rob