I am trying to track Overtime. I need to be able to Order an employee to work OT based on the number of times they have worked OT in the last 30 days. I need to sort by lowest number of days worked and then by their rank, which is the year they were hired and their number, E.g. 2006010. I also canâ€™t allow an employee to work more than 24 hours of OT in the current week. I have 3 tables tblEmployee EmpID, LName, FName,VotedSlot, PhysicalLocation tblOvertime VOTNum, EmpID, ShiftID, VOTHrs tblShift VotedSlot, Shift, S, M, T, W, R, F, Sa I have 5 shifts with varying days off on each shift. I can figure out who is here on a specific day and shift, but I canâ€™t figure out the rest.