Hello,
I have an access 07 database (attached) with a sample table with the following fields: 1. PreviousTermBalance 2. CurrentTermDue 3. TotalPaid 4. TotalBalance.
How do I ensure that, when a payment is made, the PreviousTermBalance is knocked off first to 0 (for a case where the balance is >0), before it starts knocking off what is due for the current term?
Further, just for clarity, say PreviousTermBalance is 1,000, CurrentTermDue is 5,000. What I wish to accomplish is that when a payment of say 3,000 is made, then the 1,000 balance is knocked off first, the 2,000 is posted as TotalPaid, leaving a TotalBalance of 3,000.
Is this possible? Any help will be much, much appreciated.
Thanks.
I have an access 07 database (attached) with a sample table with the following fields: 1. PreviousTermBalance 2. CurrentTermDue 3. TotalPaid 4. TotalBalance.
How do I ensure that, when a payment is made, the PreviousTermBalance is knocked off first to 0 (for a case where the balance is >0), before it starts knocking off what is due for the current term?
Further, just for clarity, say PreviousTermBalance is 1,000, CurrentTermDue is 5,000. What I wish to accomplish is that when a payment of say 3,000 is made, then the 1,000 balance is knocked off first, the 2,000 is posted as TotalPaid, leaving a TotalBalance of 3,000.
Is this possible? Any help will be much, much appreciated.
Thanks.
