topdesk123
Programmer
Good morning!
I have a table: EmployeePayRates - which consists of the EmployeeID; WorkCode; PayRate. The supplies a subform in the Employees form and supplies the information for time cards. It all works great UNTIL an employee gets a raise and their rate changes - then all previous time cards are updated with the new rate - which has a domino effect on other reports based on this information. Does anyone have any ideas on what I can do with this issue? I'm currently working on a From and To date but have been unsuccessful in getting it to work properly.
Thank you in advance!!
topdesk123
I have a table: EmployeePayRates - which consists of the EmployeeID; WorkCode; PayRate. The supplies a subform in the Employees form and supplies the information for time cards. It all works great UNTIL an employee gets a raise and their rate changes - then all previous time cards are updated with the new rate - which has a domino effect on other reports based on this information. Does anyone have any ideas on what I can do with this issue? I'm currently working on a From and To date but have been unsuccessful in getting it to work properly.
Thank you in advance!!
topdesk123