Sub Form Total in Main Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

solar - 31 Mar 2007 15:34 GMT

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.

Reply to this Message

Ken Snell (MVP) - 31 Mar 2007 16:46 GMT

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).

Signature

Ken Snell
<MS ACCESS MVP>

> Hi,
>
[quoted text clipped - 19 lines]
>
> ngr.

Reply to this Message