Solved Query or a function to calculate balances automatically (1 Viewer)

I am alive

Member
Local time
Today, 09:10
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.
 

Attachments

  • FEES PAYMENTS.zip
    51.6 KB · Views: 530

Gasman

Enthusiastic Amateur
Local time
Today, 06:10
Joined
Sep 21, 2011
Messages
14,048
@I am alive
Changing your forum name is not going to hide any crossposting?

 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:10
Joined
May 7, 2009
Messages
19,169
see Brenda's record.
 

Attachments

  • FEES PAYMENTS.zip
    63.1 KB · Views: 450

Users who are viewing this thread

Top Bottom