AnsweredAssumed Answered

Adding the values from one field that has many records -Please help!!

Question asked by JonHodge on Nov 23, 2011
Latest reply on Nov 25, 2011 by JonHodge

Title

Adding the values from one field that has many records -Please help!!

Post

Hi,

 

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.

Thanks,

Jon

Outcomes