summing values (Grand Total) that appear in Header

[Guest]

In my report, I have a header with the Manager's name and 12 "columns" that
sum up the detail section. Now there are 5 other text boxes on the Manager
Header that are doing calculations that are not in the detail field below it.

I am doing a grand total at the bottom of the report and I can get all the
fields that appear in the detial secion, but when I try to sum up the other
text boxes, I get a parameter box when I run the report.
Is there any other syntax that will work other than Sum()?
THanks!

 

[Duane Hookom]

You can't sum controls. You can sum expressions based on fields in the
report's record source.

You may need to use running sums.

 

[Guest]

I figured it out just a couple minutes ago. I just used the same
calculations up top with the grand total text boxes at the bottom. Seemed
easy enough for me.