Calculation in a Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top