I have an PatientsEmployeesSchedule table that consists of the following:
Day (date of schedule)
From (time schedule started)
To (time schedule ended)
Now I have another table that consists of EmployeeID and days only (for what we are concerned now), and users would like to see next to each record of table2, if that employee worked at least 30 hours for that week (from Sun to Sat), what is the best way to accomplish that in performance matters?
FYI- front end is MS Access and back end is SQL.