4 Replies Latest reply on Jan 13, 2016 6:59 AM by hongman

    Calculate totals based on another set value

    hongman

         Hi

       

      Cant seem to get this right!

       

      I have 2 tables:

       

      Operative Tracker:

       

      ID #

      Date (drop down)

      Operative (drop down referring to Operative Database:Name Field)

      Site (drop down, referring to Site List:Site Name Field)

      Time Arrived

      Time Depart

      Total Hours

       

       

      Site List, which consists of these fields:

       

      ID #

      Site Name

      Site Address

      Site Contact

      ...etc

       

      So the idea is we can log what site each operative has attended and for how long, on a specific day.

       

      I want to add a field on the Site List which will automatically calculate the total amount of hours registered against that specific site. So if I had 3 operatives on Site A for 10 hours it would show 30 hours. The next day if the same happened, 60 hours.


      How do I do this?