Sum of Sum

[opostal]

I have a report from a user input query that lists the data and has it broken down into three "tiers" or subcategories. The last tier contains 4 fields, one of which is a numerical value. On the report built from the query, at the top of the third tier I use the =Sum function to give me a total qty of the numerical values in that tier. My new problem is I find that I need to additionally get a sum value of all of those sum values in the tier above that. Is there an easy way to perform a Sum(SumX) type function?

 

[Kryst51]

You would use the SAME expression as you used in your tier form, just put it in the footer for the section 4 tier that you are totalling as opposed to the footer for the 3rd tier section.

 

[opostal]

Wow it is that simple. So lets pretend I did not post this as I may have had a bad case of "forest for the trees" syndrome...

Thank you very much.

 

[Kryst51]

You are so welcome! I am glad that it worked for you. btw, There are no stupid questions, how would you know unless you had done it before?