AnsweredAssumed Answered

Copy Value from a field to use in a calculation

Question asked by JohnSherwin on Aug 16, 2013
Latest reply on Aug 16, 2013 by JohnSherwin

Title

Copy Value from a field to use in a calculation

Post

     Hi,

     I have a time sheet database with several tables: Users, Rates, Hours, Joblist, Invoice, Quotation.

     In the Rates table I have 3 records showing fields: Rate ID, Rate Description and Rate Letter as follows:

     1

     B

     50.00

      

     2

     A

     100.00

      

     3

     C

     0.00

      

     In the hours table I have fields and calculations giving me the total hours by a staff member, at a particular rate and a particular activity, this total hours by those 3 parameters are presented in a summary field. 

     I want to add a further calculation field that will multiply that summary result x the value associated with rate A, B or C in the rates table.

     As I said, I am a newbie and cannot figure out how to get a calculation to extract the correct rate from the correct record in the rates table. I want 1 calculation to copy the rate for A, another to copy the rate for B and another to copy the rate for C.

     I have been trying lookup, get, case but it is a bit trial and error, mostly error.

     Any help would be great.

Outcomes