I have a two tables. tblsalposact shows EmpName and a list of Effective Date Salary went into affect and the hourly rate. Tbltimesheet shows EmpName Actual time and the Date of Entry. A person making $1.00 an hour makes an entry in tbltimesheet on 5/1/ for 60 minutes. Cost will be $60.00. If the hourly rate changed to $1.10 an hour for that person with an Effective Date Salary was entered on 5/2/2015 and that person makes an entry in tbltimesheet on 5/2 for 60 minutes cost would be $66. In addition sometimes a salary change would happen after a person makes an entry so I guess I would have to trigger an effect after hourly rate is changed from another part of the database. So what would my query looklike to reflect the multiple salary changes? Thanks for the help. FIle is attached.