Holiday DB Tweak

[jj72uk]

Ok, the title doesnt do justice to the question but its tricky to capture the problem in a line.

Attached is a simple DB that has been created for the purpose of managing holiday entitlment and booking for a small group of people. It also allows you to book appointments for each team leader, all which works correctly.

Within our business there has been a change of how holidays are worked, instead of taking a day off or a half day off its now down to hourly entitlement, so instead of getting a yearly daily entitlement they now get a yearly hourly entitlement.

All I want to change is 2 things.

i) On the right box, named holidays, it has the date, half day, maternity etc etc

What I want is the half day box to be changed to hours taken and then the entitlment recalulated correctly.

I cannot seem to figure this out.

ii) Not as important, but would be nice, is if a team leader tries to book a holiday when there is already 2 off on that day it will come up with a warning message or something similar.

Thanks for your quick responses.