I'm trying to complete a project in Access that is clearly beyond my skill level and could use some help.
I've got a query that shows all our employees (100+) by seniority. Now I'm trying to figure out how to set the query to start at the first employee with 11/1/2015 8:00AM and in 10 minute increments assign each employee a meeting time to select annual leave for next year. The trick is to schedule them from 8:00AM - 4:30PM with nobody from 12PM-12:30PM and if they are after 4:30PM start the next day.
I was thinking I could call a function from the query but am having issues with getting this started.
Thanks