Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

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

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
Hubbsjp21
Asked:
Hubbsjp21
1 Solution
 
puppydogbuddyCommented:
MS ACCESS has the same function.  See IPMT on this function list:

http://office.microsoft.com/en-us/access/HP011353121033.aspx
0
 
geekspeaknowCommented:
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
 
Hubbsjp21Author Commented:
Thanks for the link.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now