Summing Calculated Text Boxes From Detail In Footer

[Help.Chris]

Hi everyone,

I am having a problem summing a text box in the detail section, in the report footer.

The text box contains a complex formulae, but is named.

I can sum the fields refered to by the text box using sum([Main Operator Earnings]), but if i refer to the name of the text box using the fields, and run the report, I get the message that it can not find the field "My text box name"

I have tried putting the complex formulae in the footer, surrounded by sum(), to which the report runs, but when you reach the final page where the totals should be, it returns to design view.

Any help would be greatly apprecieted, I have tried everything I can think of now.

Thanks

Chris

 

[KevinM]

Put your formula in a query as an expression.
Base your report on this query.
You should now be able to Sum this expression just like any other field.

HTH