Calculating a payment

[Brian0721PA]

What is the formula for calculating a monthly payment on a mortgage in a form? is this possible. I have the loan amount, term, and interest rate. I can do this in excel, but how in access?

Thanks alot!!


Brian

 

[Mark Wild]

In the cell on the form where you want to show the result, set the data control source to = then your formula, refering to the names of the fields that contain the data.

Eg =[tbInterestRate]*[tbTerm]

 

[Brian0721PA]

What I have so far

Here is what I have so far: =Pmt([Interest Rate]/12,[Term],-[Loan Amount]) It's giving me some wacky number that is way out of range. Any suggestions?

Thanks alot!

 

[Mark Wild]

Have you got the term as # yrs or yrs*periods in year?

 

[Brian0721PA]

Term

I have the term in number of months. Maybe it should be years?