Skip to content

PMT function in Access

April 9, 2014

This tutorial was done in version 2013 yet will work with 2007 and 2010.  The PMT function calculates the monthly payment of a loan based on interest rate, # of payments (years), and the present value of the loan.  This is done in an Access query. I can also be done in a form or a report.

Advertisements

From → Access

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: