Calculation in reports

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

Guest

I want my report to calculate the total of a group of cells. I have a report
that shows a daily total but I want all the daily totals figured at the end
of the report. How do I do that?
 
Slam,
For example...
If = Sum(Daily)
yields the correct total for the day in your Daily Footer, then...
= Sum(Daily)
will yield the Sum of ALL daily totals when placed in the Report Footer.
hth
Al Camp
 
Thanks for the help but I thought in the report expressions had to use
brackets as well as parentheses. =Sum[(Daily)]?
 
Thanks for the help but I thought in the report expressions had to use
brackets as well as parentheses. =Sum[(Daily)]?
Click to expand...

If the Field or control name has no spaces, the brackets are optional. If
you do use them, you'd have to use them like this:

=Sum([Daily])

they go INSIDE the parentheses.

Tom Lake
 
Tom's response is right on.
That's why I never use spaces in ANY Control Names. Then I never have to
use brackets when referring to them.

Did my original answer give you the correct calculation?
hth
Al Camp

slam41 said:
Thanks for the help but I thought in the report expressions had to use
brackets as well as parentheses. =Sum[(Daily)]?

AlCamp said:
Slam,
For example...
If = Sum(Daily)
yields the correct total for the day in your Daily Footer, then...
= Sum(Daily)
will yield the Sum of ALL daily totals when placed in the Report Footer.
hth
Al Camp

the
end
Click to expand...
Click to expand...
 
Thanks everyone for the help. I tried the suggestions and got an error. Here
is my situation-my query totals daily totals for hours used*20 to give me a
daily "TotalCost" now these daily totals show up in the report just fine. I
then drag a dailt totals to the report foot and under the properties control
source I typed =Sum([TotalCost]). When I look at the report all it says is
#error. What am I doing wrong? I just want it to take the daily totals for
all days and give me a grand total at the bottom of the page.
 
Back
Top