Scribd
Upload
65 views1 page

Loan Table Calculate in Access

The document outlines steps for creating a loan table and performing calculations related to loan payments. It includes instructions for creating records, designing queries, and using functions such as Pmt, Ppmt, and Ipmt to calculate loan payments. The formulas provided utilize interest, time, and amount from the loan table to compute payment values.

Uploaded by

chakrabortybittu642
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
65 views1 page

Loan Table Calculate in Access

The document outlines steps for creating a loan table and performing calculations related to loan payments. It includes instructions for creating records, designing queries, and using functions such as Pmt, Ppmt, and Ipmt to calculate loan payments. The formulas provided utilize interest, time, and amount from the loan table to compute payment values.

Uploaded by

chakrabortybittu642
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

LOAN TABLE CALCULATE

Create table>CREATE SOME RECORD>create menu>query design>select


table>add>click update to field>click update cell>builder>select table>create
function>save query>double click on the query>yes>yes.

Pmt:

=Pmt([LOAN TABLE]![Interest]/12,[LOAN TABLE]![Time]*12,[LOAN TABLE]!


[Amount])

Ppmt:

=PPmt([LOAN TABLE]![interest]/12,[LOAN TABLE]![installment no],[LOAN


TABLE]![time]*12,[LOAN TABLE]![amount])

Ipmt:

=IPmt([LOAN TABLE]![interest]/12,[LOAN TABLE]![installment no],[LOAN


TABLE]![time]*12,[LOAN TABLE]![amount])

You might also like