Access query to assign values automatically based on conditions

Question

Good day

I've created a High School Examination Management database. 

I have a table with all the invigilators [Invigilators] and a query that calculates the start times for each invigilation session [Invigilation Time Slots] (Thank you, HansV for your help with that!)

Now I want to create a query that will take my StaffID field in [Invigilators] and assign an invigilator to each timeslot for each session in a new query, based on the current queries results [Invigilation Time Slots].

Conditions:

1. In my [Invigilators] table I can add dates/times of when a person is not available.
2. One person may not be used in more than 2 sessions a day.
3. If a person is on for two sessions on a day, they must be back-to-back. 
4. All staff must have the same amount of sessions over the examination period.

Current query (Invigilation Time Slots) results:

Is that at all possible? How can I achieve this?

Thank you!

Answer 1

I don't think you can do that with a query, it would require extensive VBA coding. I fear it's beyond the scope of the help I can offer. Sorry!