Calculating subforms

[Steve Moss]

Hi
I have a main form with two sub forms on it. The first is Products used,
with a Unit Price, Qty Used and a Subtotal for this row. This subform has a
number of rows, and I would like to calculate the total of the Subtotals.
My second subform is a calculation of labour costs. I would Like to
Calculate the Totals for the Subtotals and the Total Labour added together.
This is to be displayed on the main form.
Sorry long winded, can anyone help

Steve

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates this plus a number of
other problems with referencing subforms and subsubforms.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Steve Moss]

Cheers Roger on my way now.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates this plus a number of
other problems with referencing subforms and subsubforms.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L