Total of all sum for specific boxes on reports

[Debbie]

I've created a report that has some auto calculations in it - i.e.
=[per1]*[total at odds] this works great and does what it is suppose to do
however I also have a section in my report footer to show the sum of totals
for each specific section - i.e. =Sum([total at odds]) It doesn't grab all
the numbers to give me an accurate total. I am running the report off of a
specific query. My goal is to provide a summary page in my report that totals
each number column. Any hints of what I may be doing wrong.
Thanks

Debbie

 

[Duane Hookom]

It isn't clear what you want. You mention "section in my report footer".
What's that?

You can total expressions based on fields from your report's record source
in both Group and Report Headers and Footers. Maybe you need something like:
=Sum([per1]*[total at odds])
If this isn't what you want, you need to be a little more desciptive of your
report sections, data, and desired display.