Sum of Totals of Subforms

[kmanji]

Hi All. My first post here... an Access noob, and learning fast

I am designing a quotation that has a main form frmNewQuotation, and subforms frmLineItemCurtains, frmLineItemAccessories, etc, all linked by the Quotation Job Number. Each subform computes the unit qty, unit price, and subtotals perline

I have managed to use an unbound control in the footer of the subform to sum the totals of the subtotals each line of each subform, and that can be displayed on the main form.

Where I am stumped is - because I cannot sum unbound controls, how do I show the sum of the sum of the subtotals of each line in all the subforms?

Please HELP!

 

[pbaldy]

You can simply add them in a textbox on the main form.

=FirstReference + SecondReference ...

If one could be empty:

http://access.mvps.org/access/forms/frm0022.htm

 

[kmanji]

Thank you! This was the issue indeed...

 

[pbaldy]

Happy to help and welcome to the site by the way!