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!
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!