Booking a Time Slot

[AdamJ]

Hope someone can help.
The Background
Call Centre staff need to book time off the phones for development etc.
Each day there is an allowance for each 15 minute period.
08:00 5 Consultants
08:15 4 Consultants
08:30 5 Consultants
08:45 5 Consultants

I need a form which enables a Team Leader to check this allowance and then
book time off the phone e.g. 08:00 until 09:00.

So far I've figured this out, but what I also need it to do is, if a slot
is booked between 8 and 9 then it can remove that allowance from the Tbl
Allowance for each 15 minute slot.

Any ideas???

 

[Guest]

Bug: Determine the number of allowances possible for a day. Add two fields to
tblA [small int]. Adjust your app- to request, each morning/first log-in, how
many allowances. Populate one field with that value. The second field is a
counter.