Software

Ask something
Discussion Locked

MS Access - Amortization Formula

0 helpful
4 replies

by jgreer 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a database to perform loan amortizations however I have a slight problem. What expression would I utilize in Access to complete this task. I have attempted the IIF and IF statements but still receive an error when I enter the calculations.

4 replies

by cptomlly

You say you have a slight problem, so how about posting what you are trying now. Are you trying to save the amortization table to a table in the database?

Is there are necessity for using Access to do this? You can do an Amortization table fairly easily in Excel. See this site:
http://www.interest.com/hugh/calc/ss.html

Post back some details about how you are trying to do this in Access, and I'll see if I can help you. Are you doing this in a query or report given the principle, interest rate, and term only?

by jgreer

I have no problems running these in Excel however I am trying to automate creating over one hundred of them automatically instead of each one manually each week. I have a report with fields in it that contain term, rate and amount. The report when opened performs the calculations and then completes a mail merge. I don't need to save this information to a table for each person just have it generate a unique report. The days rates and terms are stored in a table for this information to originate and another table has the clients loan amount.

This discussion is closed to new replies.