summing values (Grand Total) that appear in Header

J

Jeffshex

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!
 
D

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.
 
J

Jeffshex

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.
 
Top