Sub totals on sub forms

  • Thread starter Thread starter Ed-Masto
  • Start date Start date
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
 
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])
 
Back
Top