Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    10

    Unanswered: More than one Product in an order - How to get TotalSum?

    Hi, I have an Order form, with an OrderInfo Subform, I can add more than one product to each order, but at the moment, the Total Price (on the main Order Form) only calculates the total for each line in the Order Info subform. I would like it to add all the totals together to get an overall total for the whole order.

    At the moment, my ControlSource is: =[OrderInfo subform].Form!UnitPrice*[OrderInfo subform].Form!Quantity-[OrderInfo subform].Form!DeliveryCharges

    Any ideas as to how to get the overall total sum? Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    =sum([OrderInfo subform].Form!UnitPrice*[OrderInfo subform].Form!Quantity)-[OrderInfo subform].Form!DeliveryCharges
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2008
    Posts
    10
    I keep getting #Error when using the Sum function

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •