What if an employee can have a maximum of 4 Jobs/Task/Orders to manage at the same time. The 4 Jobs can have different time durations overlaping other job periods for the same employee.
(My jobs last more than a day, use the first data base without a [time]attribute)
I have included an attachment of my database.
1.Can you help write a query to display employees(Carpenter_No) that have jobs less than 4 and also display the number of their current jobs.
NB:Their jobs overlap in time jobStartDate is the same as |Date_of Order| and jobEndDate is the same as |Date_of_completion| in orders table.
2.Also a query to display employee|(Carpenter_no)| who have jobs more than 4 and also display the number of their current jobs.
More illustrations found in the database example in attachment.Employee.accdb