I've been tasked with creating a database to allow supervisors to
schedule vacation time for their employees. The supervisors have been
using cumbersome Excel spreadsheets to date and are unfamiliar with
Access. Hence, I must create a very user-friendly interface that can
produce equally friendly reports. No problem, right?
I see some potential challenges:
--The database must count actual vacation time used between two given
dates adjusted for shift schedules and holidays. We operate four
twelve-hour shifts (1-4) and three 8-hour shifts (a-c). The twelve
hour shifts pose a challenge in that they don't follow a five-day work
--The databse must also alert the supervisor if the total persons on
vacation on any day for a given shift exceeds 10% for some months and
15% for other months
I've been thinking of creating a table with the year's workdays for
each shift to act as a reference for counting actual days off between
two given date/times.
I'm sure many of you have probably dealt with this or a similar
challange before. I welcome any suggestions you may have to offer.
Thanks in advance,
Sent via Deja.com http://www.*-*-*.com/
Before you buy.