Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Unanswered: Calculating Sum of values

    if i have a field called LinePrice in my "OrderDetails Subform1" and LinePrice is calculate by "=[unitprice]*[quantity]" then is it ok to use for a subtotal field located in the footer of the subform a field called OrderSubtotal calculated by =Sum([LinePrice])??

    In the main form i want my subtotal field to be =[OrderDetails Subform1].Form!OrderSubtotal but it always displays 0.00 no matter the value of the order.

    Any ideas what is wrong here?

  2. #2
    Join Date
    Aug 2004
    the order should go [forms]![from name]![subform name]![text box] Hope that helps

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    I believe you would have to use =Sum([unitprice] * [quantity]). Something about not being able to sum aggregates IIRC
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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