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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a subforms total into the main form 5
need help in vb 1
Insert Calculated Field (wrong Qty*Price = wrong Amount) 8
autsum several fields 2
In a sales quote sheet - sum totals by license type 1
Need worksheet Event for Sum 7
Make Row Total appear in Sub Form 1
Zeros 2

Back
Top