Help with Rate() built-in function

  • Thread starter Thread starter Burnett71
  • Start date Start date
B

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?
 
It works here. What are the parameter (their value) you supply? What version
are you using?


Vanderghast, Access MVP
 
Note that you may have a problem of a missing reference too.

Vanderghast, Access MVP
 
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:)
 
Back
Top