Getting sums from continuous forms

S

SeanK6876

I have a subform thats source is from a table. I have the view in continuous
forms because each record is a request for an item to be purchased. The
fields are:

LineNumber StockNumber Item Quantity Price Total (Unbound Calculation)

I would like to be able to total all the Totals to get a subtotal. This is
not a query so I don't know if it is even possible. Any ideas?
 
A

Al Camp

Sean,
Bring your table into a query behind the subform. Create a calculated
field in that query called LineTotal (your Total)
LineTotal : Price * Quantity
Now, LineTotal is a "bound" field.
Place that field on your form, and it can be added in the footer by...
=Sum(LineTotal)
 
V

Van T. Dinh

Add a Calculated Control in the (Sub)Form Footer using the ControlSource:

= Sum([Quantity] * [Price])
 
Top