Scheduling database ...
I have a scheduling database problem. The database table contains employees, dates, start times, and completion times.
However... I need the start times to synch up with specific slots.
8-10, 10-12, 12-2, 2-4, and 4-6. And insert this data into a viewing table.
If the start time and is within the slots, and the end time is within the slots, I would like the slots to be updated for each employee. If not.. I would like the slots to stay empty.
If there an easy way of doing this?
This is the format...
employee1 8-10 empty
employee1 10-12 empty
employee1 12-2 busy... customer info
employee1 2-4 busy... customer info
employee1 4-6 empty
employee2 8-10 busy customer info
employee2 10-12 busy customer info
employee2 12-2 busy another customer info
employee2 2-4 empty
employee2 4-6 busy still another customer info
What would be an easy way of doing this without programming a hundred for loops, and if then statement.
Regards,
Marc Noon
Coding is a game. Live it, love it, break it, run it.
__________________
Marc Noon
Coding is a game. Live it, love it, break it, run it.
|