Solved

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

Posted on 2007-12-05
3
277 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

705 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now