Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013
    Posts
    14

    Unanswered: calculation with many condition

    Hi everybody,
    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

    Please find the attached file for an example:
    Attached Thumbnails Attached Thumbnails ledger.jpg  

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •