Report Group Totals

[Dean]

I have a report based on a query. The report was designed
to group data by color. Each group has a report calculated
quantity total and a cost total. I also want a grand total
for the report. I added a boundbox =Sum([ColorQuantity]),
placed it in the report footer and it gives the total
quantity for the 4 colors. I then added a boundbox =Sum
([GroupCost]). Placing this box in the report footer
gives me only the last group GroupCost. Placing it in the
group section gives me each group's GroupCost. Placing it
in the page header gives me the first groups GroupCost.

The GroupCost control source is a calculated value =
[BrownCost]+[OrangeCost]+[RedCost]+[TealCost]+[YellowCost]
and it is named TotalColorCost. I have tried using =Sum
([TotalColorCost]) and =Sum([BrownCost]+[OrangeCost]+
[RedCost]+[TealCost]+[YellowCost]). Neither gives me the
grand total.

Thanks
Dean

 

[Duane Hookom]

You can only use an expression from the report's record source in =Sum().
You can't sum controls from other sections. You can create running sums on
controls in the group footers and then reference the control name in the
report footer. For instance if your group footer control name is
txtGroupRunningSum then you can place a text box in the report footer with a
control source of:
=txtGroupRunningSum
If BrownCost etc are calculated text boxes in the group footer, they can't
be referenced in the report footer to get an accurate total.