1 Reply Latest reply on Jan 5, 2012 6:04 AM by RichardWilliams

    Sum of Values from a Field

    RichardWilliams

      Title

      Sum of Values from a Field

      Post

      Hi 

       

      I am building a database for which it is possible to have multiple payments for a single job (deposit, Final payment) I have created a payment database and a job database, so when you make a payment it is recorded against that job, what I would now like to do is add all the payments for that job together and show them in a new field ie total payments.

       

      It would also be good to be able to show in another field payment amount remaining ie Total cost - payments made 

       

      not quite sure where to start with this.  currently I have all the payments made for a particular job showing up in the portal against that particular job see image

       

      Thanks for any help

       

      Rich

      Screen_Shot_2012-01-05_at_13.43.52.png