Sum of Total in datasheet view

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a sub-form in data sheet view on a main form. The
fields are Code, Description, Qty, Price Each, Total
price. Total Price is calculated by multiplying Qty X
price Each. There will be multiple lines. How can I
display the sum of Total?
 
Mark,
You can't sum an unbound calculated field in your form footer.
Create a field in your query behind the form like this...
TotalPrice : Qty * PriceEach
Now TotalPrice is a bound field, and can be placed on the form, and added
in the footer with...
=Sum(TotalPrice)
hth
Al Camp
 
Back
Top