Calculation in a Field

[Guest]

In my report I wish to add or calculate the field in one group. The more
entry entered the greater the total savings.
Example:
(Field 1) Event Saving equal to: $500.00
(Field 1) Event Saving equal to: $1500.00
(Field 2) Total Savings equal to: $2000.00

 

[Guest]

Hi Robert,

Look up RunningSum in help to see how to acheive this.

TonyT..

 

[John Vinson]

In my report I wish to add or calculate the field in one group. The more
entry entered the greater the total savings.
Example:
(Field 1) Event Saving equal to: $500.00
(Field 1) Event Saving equal to: $1500.00
(Field 2) Total Savings equal to: $2000.00

You don't say anything about how your report or table are structured,
but... assuming that you have used the Report's Sorting and Grouping
dialog to group events, you can set that group's Footer so that it's
visible. In the Footer put a textbox with a control source

=Sum([fieldname])

to sum the value in that field (use the Report's recordsource field
name, not the name of the Event Savings textbox).

John W. Vinson[MVP]