Hello,
i am trying to create an app to follow the payment of my customers.
In the basic form (form1) i have the customer details and one numeric field where i write the total money i have agreed with my customer.
In the subform (subform1) i have the payments, one record for each time with the fields "Date", "Amount" and "bank name"
I want to add all the payments, substract it from the total and return to me the money my customer owes to me.