Need a Calculation Field in a Report

[Bpmarks]

Okay. What I need to do is add a field to my report that calculates values from the column above it. For example, my report lists values of 5 records that appear as follows:
Column A
1
4
6
7
2
I need a field that gives me a sum of these numbers, but I do not want the field to appear after every record (no running sum); rather, I would like the total to appear at the end, once all the records have been displayed.

I know it sounds easy, and I'm sure its possible, but it is driving me insane. Please help. Thanks.

 

[67peshawar294]

see reply in your first post in the "other topics" forum.
jp

 

[randysmid]

Hi,
Add a report footer to your report, then add a textbox that will calculate the sum of Column A.
HTH,
Randy Smith
California Teachers Association