I concur with the Bobenator.
-Never store calculated fields in tables.
-Always provide for n number of instances (in this case payments. What if a customer was put on a payment plan for a year?)
-The query calc is good for this structure, but if you do normalize your tables you will need a different query, of course.