I'm using access 2007. In my database there is ledger query, and the fields are: Account Number, Transaction date, Deposit Amount, Withdrawal Amount, Balance and Interest. Balance is (Deposit Amount - Withdrawn Amount + Interest).
Now, Interest rate would be monthly 0.50% of previous month Balance Amount but in ledger it have to be show every transaction wise.
There is another condition for this calculation; Account Holder have to deposit before 25th of previous month otherwise interest would be 0 for currant month.
Any suggestion? Thanks
This should give you the current month's day 25. For the %, just use a If statement and set the interest rate to "" or 0. Hope this helps. Also, you will have to count back using the code.Adjust to your needs. Good Luck! Dates are not my strong suit, so test for yourself.
Me.Text15 = DateSerial(Year(Now()), Month(Now()), 1 + 1 * 7) - Weekday(DateSerial(Year(Now()), Month(Now()), 8 - 2)) + 24