Sub totals on sub forms

E

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
 
J

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
Click to expand...

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

=Sum([Quantity])
 
Top