Help with Rate() built-in function

[Burnett71]

Can anyone assist? I'm trying to use the rate() function available in the
built-in functions of the expression builder. I've used similar, such as the
Pmt() function, with no problem. When I put in the factors as prompted, I
receive a #Error. Is there a way to figure out why the function doesn't work
or another way to achieve results in an access query?

 

[vanderghast]

It works here. What are the parameter (their value) you supply? What version
are you using?


Vanderghast, Access MVP

 

[vanderghast]

Note that you may have a problem of a missing reference too.

Vanderghast, Access MVP

 

[Burnett71]

Hi Vanderghast,

For some reason, I was posting questions and though I kept checking for a
couple of days, they did not appear to be posting so I gave up. In looking
for insight on another issue today (days later), I see that my questions did
eventually post and that you offered to assist. Just want you to know I
wasn't ignoring you effort or trying to waste anyone's time.

Thank you