Adding the values from one field that has many records -Please help!!
Newbie here!! I would really appreciate your help.
I have created a very simple database for an old peoples home.
They have their staff that they want to keep track of the amount of hours holiday they take.
I created a portal within the staff database on a new tab called HOLIDAY!
There are only three fields , DATE FROM, DATE TO and NUMBER OF HOURS LEAVE
As a member of staff asks for leave they put in the dates and the admin input how many hours they have taken.
I have created out of the portal on the same tab a field TOTAL HOURS TAKEN
I would like a total from NUMBER OF HOURS LEAVE but when I use sum it only inputs the first record and not a sum of them all!
Is there a simple way to do this please? I did look at changing TOTAL HOURS TAKEN to a summary field but NUMBER OF HOURS LEAVE was greyed out.
I would appreciate any help.