I am alive
Member
- Local time
- Today, 02:53
- Joined
- Aug 29, 2020
- Messages
- 139
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.
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.