Sum on a control (text box)

[jhays]

I know that I cannot perform the SUM function on a control text box, but here is my problem. I want to perform a sum on a text box with a control source of =[EPMonth]-[BPMonth]. The [EPMonth] and [BPMonth] are other control text boxes on the report, but their numberic values change based on two different options on a form.
Is there a way to perform the SUM function on a control text box which is based on a calculation of two other control text boxes whose values change based on a form? Let me know if this doesn't make sense!

 

[dhookom]

You can't sum controls from a different section. You can duplicate, hide, and set their Running Sum to over group. If the running sum text box is named txtMonthSum then add a text box to the report footer with a control source of
=txtMonthSum

Duane
MS Access MVP