Results 1 to 5 of 5
  1. #1
    jalals is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    24

    Loan Adjusted in instalments

    Hi
    I have to find out the residual loan amount (NetLoanAmt) from the employees database. The employee takes a loan from the school administration. He has to liquidate the Actual Loan Amount (GrossLoanAmount) in 10 equal installments from his monthly salary. There are following fields in the Employee database
    1. Employee Id
    2. Employee Name


    3. GrossSalary
    4. GrossLoanAmt
    5. Instalment = GrossLoanAmt/10 (could be generated through Query – To remain constant till loan is adjusted)
    6. NetSalary=GrossSalary – Instalment (could be generated through Query)
    7. NetLoanAmt = GrossLoanAmt-Installment as on a particular date (To be derived after current month salary is paid)
    On next salary day the system should deduct the installment from the salary and also generate NetLoanAmt. It should swap till loan is adjusted.
    I need a VBA Swap function to generate the same which I could not get after doing some practice.
    Please some one help me here
    Thanks
    Jalal

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    5. Instalment = GrossLoanAmt/10 (could be generated through Query – To remain constant till loan is adjusted)
    6. NetSalary=GrossSalary – Instalment (could be generated through Query)
    7. NetLoanAmt = GrossLoanAmt-Installment as on a particular date (To be derived after current month salary is paid)
    All of these can be calculated but you will need to store the date of the first installment. I assume that the employees are paid on the last day of each month.

    This can be done in a query.

    Please see the attached database as an example
    Attached Files Attached Files

  3. #3
    jalals is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    24
    Hi

    jzwp11
    Thanks for providing the solution. The formulea worked and hence the thread solved

    Thanks once again
    Jalal

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You're welcome.

  5. #5
    sachiaks is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2014
    Posts
    1
    its very helpful thanx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. loan database
    By jlyon in forum Access
    Replies: 5
    Last Post: 07-23-2010, 07:24 AM
  2. Installment Loan manager
    By tedalmeida in forum Access
    Replies: 1
    Last Post: 03-17-2010, 07:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums