Sub Form Total in Main Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

One Simple problem which i was not able to find solution.

In a sub-Form(Deduction_Details), I have three field like
1.Sl.No (Autonumber field)
2.Deduction_Remarks
3.Deduction_Amount

I may type more than one data as "Sl.No" is already specified as Autonumber
field. I need to show the sum of "Deduction_Amount" in the Main Form.

I used the following formula in control source of the text box.
=Sum([Deduction_Details].[Form]![Deduction_Amount])

But, it is showing #Error. Is it correct ?

Could anybody please point out me where i have done mistake.

Thnx..in Advance.

ngr.
 
Put a hidden textbox in the subform's form footer section, and have it
calculate the sum by using a Sum expression. Then change the control source
of the textbox on your main form to just read the value from that hidden
textbox (no Sum in the main form).
 
Back
Top