How to do a query to find the total balance and the amount paid for each person?

[armrodnun]

Also, How can I do a query to find the three highest balances in a access table? I Am new with Access please help me! I attached the file with my thread.

 

[SOS]

Your table should not have Balance in it. Your Balance should be a calculated value in a query that comes from the total due and the amounts paid.

You can have a transactions table which when a charge is added (as a positive number) it raises the balance due and when you add a payment to that transactions table (as a negative number) it will reduce the amount due.