Sub Form Total in Main Form

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

Ken Snell \(MVP\)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sub form opens before the main form in MS Access 0
Errors with Sub Form Totals 4
referring to Subform Total in main form 1
Form Problem 0
summing 2 different totals in a continuous form 1
Shared Sub-form referring to a field in the same sub-form 2
Sub form calculations not correct on main form 2
totaling an unobund calculated control in form header 4

Top