?
Solved

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

Posted on 2007-12-05
3
Medium Priority
?
346 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 2000 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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

584 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