PraizesLiberato
Registered User.
- Local time
- Tomorrow, 02:56
- Joined
- Dec 6, 2009
- Messages
- 69
Hi,
I have a List of amount and a column next to them that indicate the balance after subtracting the opening balance with each amount in the rows below. If incase the user decides to change one of the amounts, the balances need to change and be saved into the database. This is where i face my dilema. I know how to do this in vba, as mentioned below, but i am unable to figure out if this can be done using a query.
Arrange Datewise
-Take Current Outstandings of Loan - Installment Amt
-For Loop till last date
But this way slows down the system when its on a shared drive. Could i try something different.
Kind Regards
Praise
I have a List of amount and a column next to them that indicate the balance after subtracting the opening balance with each amount in the rows below. If incase the user decides to change one of the amounts, the balances need to change and be saved into the database. This is where i face my dilema. I know how to do this in vba, as mentioned below, but i am unable to figure out if this can be done using a query.
Arrange Datewise
-Take Current Outstandings of Loan - Installment Amt
-For Loop till last date
But this way slows down the system when its on a shared drive. Could i try something different.
Kind Regards
Praise
