Copy Value from a field to use in a calculation
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:
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.