Departmental Time Keeping SQL statement
Posted on 2011-04-18
What I have are employee sign in/sign out logs in and out of departments in an access database.
Very simple data: logID, employeeID, deptID, InTime, OutTime
What was requested is the ability to input a department, start and end times and output the number of minutes worked within that time period in that department. They would like to see total minutes worked and also who worked them (two separate reports).
I am hoping that this should be able to be accomplished by a single SQL query for each report.