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

    Unanswered: Quick Expression Builder Help

    I'm trying to created a calculated field in a query and I'm having some trouble.
    The new field needs to multiply a field value in a previous query(labor cost) against a rate that is specified by a year in a set table, i.e. like a SUMIFS expression in excel based on a date. Can anyone assist.
    Attached Thumbnails Attached Thumbnails Capture.PNG   Capture2.PNG  

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    Assuming that you've built a new query based on the old query and the table, your calculated field will be:
    AdjustedLabor:[LaborCost] * [AdjLaborRate]
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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