Query or a function to calculate balances automatically

[erickemboi]

Hello everyone. I am developing Students Fees Scheduler. Kindly, please I am requesting anyone to assist me with a QUERY or a FUNCTION to automatically calculate balances when certain amount of money has been paid. It should look like this:
TOTAL AMOUNT OF MONEY TO BE PAID- let's call it x
PAYMENT DATE-
AMOUNT PAID-
BALANCE- (TO BE SUBTRACTED FROM x)
please, fees can be paid in different dates and with different amounts
Thanks in advance.
Kindly check attached database. God bless you.

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...ically.319134/

[ranman256]

you actually need more tables,

tFeesCharged tbl:
FeeID(autonum), FeeName, studentID, FeeDate, note

tPayments tbl:
PayID(autonum),studentID, DatePd, AmtPd, FeeID


1 table the holds all fees charged to student
1 table the holds all payment made by student
then a query is run to sum each table, the difference will be balance due.

[erickemboi]

When I create the two tables, when i try to edit i get "THIS RECORDSET IS NOT UPDATEABLE"