Total Amount

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

I have a form that has a subform.
Header Information and a Subform for detail information.
I have all the list of items and extended price in the
subform, how can I total the lines in the subform and
show the total order amount in the header section which
is the main form.

Any ideas??
 
In the header or footer of the subform, add a control to sum the prices
(e.g., Sum([ExtPrice]). Be sure to name the control, i.e., SumExtPrice

In the Main form, create a control to reference the SumExtPrice control in
the subform, i.e., = [subform]![SumExtPrice] ... or something like that as
I don't remember the syntax for referencing subforms off the top of my head.

Cameo
 
Back
Top