Looking to use cumipmt function or code in access form. Have searched high and low for the correct code or possible reference library.
What I have tried x=cumipmt(rate,term,lnamt,start,end) and not working. Anyone have the answer. Thanks

Access doesn't have that. That would have to be a custom function that you or someone else would need to provide.


http://downloads.btabdevelopment.com/screenshots/welcometoawf.png

Actually, I think there are ways you can use Excel (as long as the Analysis Tool Pack add-in is added in).

This should help:
http://support.microsoft.com/default.aspx/kb/198571

I've tried the reference library earlier "microsoft excel 11.0 object library" and did a browser check for cumipmt and nothing. I'll try again though. Thanks

I've tried the reference library earlier "microsoft excel 11.0 object library" and did a browser check for cumipmt and nothing. I'll try again though. Thanks
It isn't there. You have to make sure to go through the ADD-IN approach (see the part on the link I gave down near the bottom).

=Sum(IPmt([intrt]*0.01/12,("1"-"5"),[term],-[lnamt])) this is an expression that should work but the 1-5 is a problem and it's not working. The 1-5 represents the start month & end month.

putting numbers in quotes makes them TEXT and a formula like that is not looking for text.