How do I calculate total interest payments on a loan in a query?

[Cathy F.]

I need to calculate the total interest on a loan in an access query. The
CUMIPMT function in excel does not work in access.

 

[Wayne-I-M]

Hi

You need a tell your application
the loan amount
number of payments
interest rate

try this
http://www.functionx.com/access2003/Lesson34.htm