Sub totals on sub forms

[Ed-Masto]

Hi All:

How do I put totals on a subform. For example, I have an sales order form
with the order details on a subform. I would like the Quantity and Extended
Price of all the lines in the sub form to sub total for the order. Any ideas?

Ed

 

[Ed-Masto]

I figured it out. The new Totals feature in 2007 is awesome!

 

[John W. Vinson]

Hi All:

How do I put totals on a subform. For example, I have an sales order form
with the order details on a subform. I would like the Quantity and Extended
Price of all the lines in the sub form to sub total for the order. Any ideas?

Ed

Put two textboxes in the Footer of the subform, with control sources like

=Sum([Quantity])