On 30 Aug 2005 05:57:18 -0700, wrote:

"The report footer's sum (using a Sum([fieldname]) has
the correct total sum value when examined from within groups."

OH!! My bad. I thought you were saying to use the fields that are the
group conters, not the actual data fields. NOW I see what you are
saying, and yes, that works, and is simple! Thank you very much. The
only downside I can see to that is the very slight possibility of it
not working correctly under certain conditions (like a report with two
groups, one with a sub-total of 0, where the other group that has all
the money is the one that get's it's subtotal hidden). But those cases
in my application would be extremely rare. Even if that would be a
concern, I would think that a field could be added to the source query
that would simply be "1" AS "line count", then sum that (with invisible
controls), and use those totals and sub-totals instead of the real
values.

Thanks for your help!

You can use hidden count fields [ =Count(*) ] then, instead of SUM. This will
solve the problem with zero sums.