Report calculating

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

Guest

I have a report with all sections (report header & footer, page header &
footer, detail header & footer). It appears that in each section the rules
change as to how I can calculate.

This report is grouped by employee with costs. I can subtotal the costs in
the detail footer by using =Sum([FSAAmount]). The name of this new text box
is FSATOTAL. FSAAmount is the control source of the text box I am
calculating. The name is FSAAmt. Now when I get down to the report footer,
I have to use =Sum([FSAAmt]) to get my grand total. Why can't I use the name
of my subtotal box FSATOTAL and why do I now have to use the Name of the box
and not the control source like I had to at the detail level? Now also on
the detail footer level I have made other calculations for each employee such
as balance. Here I had to use the Name of the box to calculate and have
given each new box a Name. Now I would hope I could use the Names of these
boxes at the report footer level to add these for a grand total, but no that
would be too simple and make sense. It appears the only way I can get them
to calculate is to use the control source in the brackets which is a formula
and is long and crazy. And of course, it is not calculating correctly. I am
missing something somewhere. Excel where are you when I need you!
 
I don't know what you are attempting to do. You can always sum fields or
expressions from your reports record source. You can't sum controls from one
section to another (it just doesn't work).

I have responded to a more recent question of yours regarding summing values
from headers or footers.
 
Back
Top