Continuos form and summing. (1 Viewer)

Hi All,

I have to admit that I have been staring at this this problem for some time now and can't seem to solve it. Hopefully someone from this form will be able to help...

The attached jpeg of my continuos form has the "traditional" access #Name? error in it. The text box's contain the formula to sum each column they are under i.e: =sum([txtamount]) , =sum([txtFinalForecastCost]),
=sum([txtCostToGo]). They are located on the form footer section. If I delete the last text box the other two text box's sum ok, but all three generate the #Name? error. Any ideas on how to get around this so all three sum?

This continuos form is a sub form of the main form and the last column is a calculation of: Forecast - amount = CostToGo

Access 97

Thank you.

Have a look at the attached sample, it will show you how to get a total from subform to main form.

You can't Sum calculated fields like that, you have to repeat the calculation
=Sum([fieldA]-[FieldB])

RESOLVED - Thank you

Thanks Rich and Ansentry that worked well.