Help with Rate() function in expression builder

T

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?
 
J

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
 
B

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:)
 
B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Rate() function in Expression Builder 3
Interest Rate Calc using Rate() Function 1
Expression Builder help. 8
Expression Builder 7
Expression Builder cuts off long expressions 2
Decimal places and Date Range in Expression Builder 2
Need Help With Rate() Function in Expression Builder 2
Help with Rate() built-in function 3

Top