Sum a Field in a Report

[1ooo1]

Hi,
How can I get a total for a field in the footer of a report.

FIELD_A FIELD_B FIELD_C
3 19 5
7 11 1
9 15 10
4 2 7
6 1 5
--------------------------------------------
29 48 28 <<I NEED THESE TOTALS
--------------------------------------------
I have tried a few things, but the closest I can get is a running total, which gives me an additional total after each record..which is not what I want, all I want is the Sum Total of the field in the Footer. This is probably the simplest thing to do, but I am stumped. Can anybody help me !!

Ken

 

[randysmid]

Hi,
1) Place 3 text boxes in the footer of your report.
2) For the control source for the first text box, enter this code: = Sum([FIELD_A])
3) Repeat this process for the other two text boxes, replacing [FIELD_A] with [FIELD_B], etc.
4) You may need to change the formatting to Standard, with zero (0) Decimal Places.



HTH,
Randy Smith
California Teachers Association

 

[1ooo1]

Thanx Randy,
I managed to find the answer to my question at this thread thread703-474037 , I needed to have the result displayed in the Report Footer and not the Page Footer. =SUM([FIELD_A])

Ken