Help with Rate() function in expression builder

[Tomdb71]

I am trying to use the built-in rate() function in the expression builder in
a query. I put in all of the values per the prompt, but I keep getting a
#Error. Any insights?

 

[John Spencer]

Not really, you did not post the expression you are using and the values you
are inputting.

Rate works for me as long as I am inputting valid numbers and as long as I
input all the parameters.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[KARL DEWEY]

Post what you did and where you did it.

 

[Burnett71]

Ki Karl,

For some reason, I was posting questions but 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

 

[Burnett71]

Hi John,

For some reason, I was posting questions but 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