summing values (Grand Total) that appear in Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

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