Solved

Does MS Access(2003) have a counterpart to the IPMT Function in Excel?

Posted on 2007-12-05
3
301 Views
Last Modified: 2013-11-27
I am trying to calculate the amount of interest due (on Mortgages) for a list of loans that all have different origination dates, interest rates etc. for a given month.  The idea would be that as each "first of the month" approached, I would be able to see what the interest due is on each loan in the list for that month.  This is easy to do in Excel because Excel has a Financial function that calculates it.  Does MS Acces have a similar Function?
0
Comment
Question by:Hubbsjp21
3 Comments
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 20414846
MS ACCESS has the same function.  See IPMT on this function list:

http://office.microsoft.com/en-us/access/HP011353121033.aspx
0
 
LVL 2

Expert Comment

by:geekspeaknow
ID: 20414864
It looks to me like it exists in Access.  I think if you make a new query and put your formula in the field box and then switch to the data view, it will calculate the field for you.
0
 

Author Closing Comment

by:Hubbsjp21
ID: 31412956
Thanks for the link.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question