Sum in a Footer Text Box

[Imconfused]

I'll try to explain this the best I can hoping one of you can help. I have created a report that groups records based on a common reference. In some cases, the group may contain 1 record or it may contain 100. Each record has different field values, many of which are dollar values. Within the report, I have performed certain calculations in an expression (text box) which displays variances of the totals of certain fields within each group. Within the footer, I want to total those expressions. I have tried to sum the calculation expression, I have tried to sum the text box, and several other methods. I hope I have described this problem well enough.

 

[Imconfused]

I have been able to get the correct result by setting up a running sum text box for each group. The report is actually a few hundred pages long as there are about 36,000 records. However, this is quite cumbersome looking and does not provide for a professional looking report that provides the end result data in the footer.

 

[CosmoKramer]

For a quick fix you could set the Visible property to No for the detail running sum text box....

Hoc nomen meum verum non est.

 

[Imconfused]

How would I get the end result of the running sum to appear in the report footer?

 

[CosmoKramer]

Add another text box to the report footer and set its control source to the running sum text box.

Hoc nomen meum verum non est.

 

[Imconfused]

Thanks a million