All - I'm working with an MS ACCESS 2010 db developed for timekeeping purposes.
One table (TRHISTORY) is used to collect hours (HRS) and cost (COST) per job, per employee (EMP_ID). The other table (WAGE) holds rate data (ImgRate) for each employee (IngEMP_ID).
TRHISTORY table fields:
EMP_ID
HRS
COST
WAGE table fields:
IngEMP_ID
ImgRage
My question -
How do I calculate cost using the above fields (TRHISTORY.HRS and WAGE.ImgRate) and update the COST field in each TRHISTORY record accordingly?