AnsweredAssumed Answered

Sum of Values from a Field

Question asked by RichardWilliams on Jan 5, 2012
Latest reply on Jan 5, 2012 by RichardWilliams


Sum of Values from a Field




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