Inserting a Grand Total

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
 
H

heg

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group Totals and Grand Totals on each page 3
Grand Total for a calculated column - Access 2007 1
One and One-half Columns and Grand Total on Same Page (?) 3
Filter on Grand Total 2
Can't calculate Grand Total of several other expressions 1
Grand total 2
Calculated control: Grand Total 8
Report Footer Grand TL not appearing on one page report with colum 4

Top