cumipmt code

[mstephen]

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

 

[boblarson]

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

 

[boblarson]

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

 

[boblarson]

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

 

[mstephen]

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

 

[boblarson]

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).

 

[mstephen]

=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.

 

[boblarson]

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