Calculation in Access Form and Subform

[Fav]

I want to add all sub-totals in my sub-form to a total in the main form. How
do I do it

 

[NetworkTrade]

You need to pull them all together in an event; possibly the OnCurrent event
of the form...(although I'm not 100% certain the subform values are set
before the main form is current...try it)....or maybe you want to put in a
calc button and use its OnClick event...

Each value is identified by: Me.SubformName.Form!ControlName

the 'Me' and the 'Form' are literal - otherwise insert your actual names

 

[vbasean]

I want to add all sub-totals in my sub-form to a total in the main form. How
do I do it

I use the dsum function
add an unbound textbox to your form
go to the textbox properties and set it's datasource something like
this
=DSum("[field you want to total]", "[table field resides in]","[child
field of the related table] = " & [parent field on form])

http://www.techonthenet.com/access/functions/domain/dsum.php

 

[nomadk]

add an unbound text box on your form with a Control Source like

=SubFormName.Form!Subtotal1+SubFormName.Form!Subtotal2+SubFormName.Form!Subtotal3...