Hi,
I'm trying to create a employee payroll system. I have log hour table which keeps record of clock in and clock out. I'm able to create total hour worked by each employee by calculating all times from the log hour table associate to each employee. I have payperiod table which have start date and end date attribute. Therefore, I want to be able to just calculate hour worked for that payperiod range. Right now total hour in query sums all the log hour from loghour table for each employee.
Can someone help me with this. I'm newbie to Access.
I'm trying to create a employee payroll system. I have log hour table which keeps record of clock in and clock out. I'm able to create total hour worked by each employee by calculating all times from the log hour table associate to each employee. I have payperiod table which have start date and end date attribute. Therefore, I want to be able to just calculate hour worked for that payperiod range. Right now total hour in query sums all the log hour from loghour table for each employee.
Can someone help me with this. I'm newbie to Access.