Trouble with sums in report

  • Thread starter Thread starter Brian Snelling
  • Start date Start date
B

Brian Snelling

Hi,
Trying to do a report based on a form/subform. Did a query to include
all data from form and subform and made a report where everything shows up
fine and is grouped as I want it. BUT. I can sum data from the report detail
section just fine but cannot sum data that is in the next level up - the
DailyRecordID header. Is there a way? must I use VBA? I'm a slow and simple
code writer.
Any help appreciated
Brian S.
 
Brian said:
Trying to do a report based on a form/subform. Did a query to include
all data from form and subform and made a report where everything shows up
fine and is grouped as I want it. BUT. I can sum data from the report detail
section just fine but cannot sum data that is in the next level up - the
DailyRecordID header. Is there a way? must I use VBA? I'm a slow and simple
code writer.
Click to expand...


Explore using a text box (in the group header/footer) with
its RunningSum property set to Over Group to provide a total
to another text box in the group footer of the level above
the running sum text box. Set the RunningSum property to
Over All to provide a total to a text box in the report
footer.
 
Thanks for the quick reply Marshall. So far no joy but I;m a novice and will
keep at your suggestion till I'm sure one way or the other

Brian S.
 
On rereading my reply, I see how it's clarity leaves a lot
to be desired. Let me try again.


report heaser
. . .
xxx group header
. . .
Daily group header
text box txtAmount
ControlSource: fldAmount
text box txtRunGrpAmt
ControlSource: fldAmount
RunningSum: Over Group
text box txtRunGrandAmt
ControlSource: fldAmount
RunningSum: Over All
. . .
Detail
. . .
Daily group footer
. . .
xxx group footer
text box txtGrpTotalAmt
ControlSource: =txtRunGrpAmt
. . .
report footer
text box txtGrpTotalAmt
ControlSource: =txtRunGrandAmt
. . .
 
Back
Top