how to sum total two subform to text in main form

[SalmanZeiad]

 

[bob fitz]

Assuming that you have a total on each of two subforms and you want to add these together and show result on the main form.

You the following expression in the text box on the main form. You will need to replace some of the expression with the real names used in your database:

=[NameOfSubForm1].[Form]![NameOfFirstTotalTextbox] + [NameOfSubForm2].[Form]![NameOfSecondTotalTextbox]

 

[SalmanZeiad]

Assuming that you have a total on each of two subforms and you want to add these together and show result on the main form.

You the following expression in the text box on the main form. You will need to replace some of the expression with the real names used in your database:

=[NameOfSubForm1].[Form]![NameOfFirstTotalTextbox] + [NameOfSubForm2].[Form]![NameOfSecondTotalTextbox]

thank you so much>>>>it`s work

 

[bob fitz]

thank you so much>>>>it`s work

You're welcome. Glad to help if I can

 

[SalmanZeiad]

thank you so much>>>>it`s work

i noted when any value is empty give error [#Type!]

 

[bob fitz]

i noted when any value is empty give error [#Type!]

Try:
=Nz([NameOfSubForm1].[Form]![NameOfFirstTotalTextbox],0) + Nz([NameOfSubForm2].[Form]![NameOfSecondTotalTextbox],0)

 

[SalmanZeiad]

Try:
=Nz([NameOfSubForm1].[Form]![NameOfFirstTotalTextbox],0) + Nz([NameOfSubForm2].[Form]![NameOfSecondTotalTextbox],0)

WOW it`s done ,,,but without comma 0 ...,0

thanks alot

 

[bob fitz]

WOW it`s done

thanks alot

You're welcome