Hi ..... if anyone can help with this i will be eternally greatfull, i just can't seem to get my head round it and am hoping that someone out there will be able to assist.
I have to create an allocation sheet, or chart, that visually depicts the allocation of seats between the hours of 08:00 and 21:00 in any given day.
I have a table with the employees name, seat number and start time and finish time.
Every employee is allocated a seat but when one person finishes work someone else will sit in that seat for there shift.
In short given the basic data i have i need to produce some sort of report that when looked at will show if any seats are unoccupied at any point in the day and at what times.
It sounds simple but its not .... Please Help!!!