Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012

    Unanswered: Expresssion builder doesn't have the correct fields

    Hi Everyone-

    I have a query that pulls Prices & multiple Upcharges for an item from a form. I group the Prices by Avg and the Upcharges by Sum (so that theres just one record/row per item). When I go to create an expression for Total Price (AvgOfPrice + SumOfUpcharges), it makes me input the AvgOfPrice and SumOfUpcharges.

    I think the problem is that the Builder doesn't have fields for Prices like my query does (it shows AvgOfPrices when the query field is just Prices). If anyone can take a look and see what the problem is I'd be really grateful. Thanks!
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2004
    Cary, NC
    You can:

    1. Use a second query that references this one
    2. Use the sum & avg functions in your Total Price
    TotalPrice: Sum([Upcharges]) + Avg([Price])


Posting Permissions

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