Inserting a Grand Total

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

Good morning,

I have two questions really.

1) Does anyone have info on new MS report writing software
due out in 2004?

also,

2) I am trying to get a grand total for a calculated field
I have in a group footer. Is this possible? Note: I am
new Access report writing and do not use VBA).

TIA

Jamie in Massachusetts
 
Jamie,
I think I can help you with question 2. In the Properties
for the calculated control (text box) set the RunningSum
property to Over Group. This will display a total for the
data in each group.

If you want a grand total for all groups set the
RunningSum property to Over All, and put that control into
the report footer, not the group footer. The control
source property should be the name of the text box that
calculates the running sum.

Howard
 
Back
Top