Hello Experts!!!!
I have two tables EMP as a master table and log time as a transaction table.
EMP has emp code and ST hours for each employee, all emp code uniquie. Log time can have same employee multiple times. I need to calculate total ST hours and OT hours for a certain date for all employees that worked on that day.
Table structure and details in attached image.
Appreciate your help.
Bookmarks