Query or a function to calculate balances automatically (2 Viewers)

I am alive

Member
Local time
Today, 19:01
Joined
Aug 29, 2020
Messages
64
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.
 

Attachments

  • FEES PAYMENTS.zip
    51.6 KB · Views: 99

Gasman

Enthusiastic Amateur
Local time
Today, 17:01
Joined
Sep 21, 2011
Messages
9,084
@I am alive
Changing your forum name is not going to hide any crossposting?

 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 00:01
Joined
May 7, 2009
Messages
14,176
see Brenda's record.
 

Attachments

  • FEES PAYMENTS.zip
    63.1 KB · Views: 80

Users who are viewing this thread

Top Bottom