You have entered an operrand without an operator

Question

I am having trouble with the quation in Access.  The syntax error is you have entered an operrand without an operator:  INTEREST SALE DATE: Round([MONTHS]/100*[TRANSFER/DUE AMOUNT OUTSTANDING], IIf([TRANSFER/DUE AMOUNT OUTSTANDING] is not [>]1000,[.0056]*[TRANSFER DUE/AMOUNT OUTSTANDING]),2)) Can someone help me with this?

Answer 1

Hi,

Not sure you can use "is not." Try something like this:

INTEREST SALE DATE: Round([MONTHS]/100*[TRANSFER/DUE AMOUNT OUTSTANDING], IIf([TRANSFER/DUE AMOUNT OUTSTANDING]<=1000,[.0056]*[TRANSFER DUE/AMOUNT OUTSTANDING],2))

Hope it helps...

Answer 2

Thank you very much.  I will try.

Answer 3

Hi Terry X,

It didn't render the results that I need.  I am trying to recalculate the interest for [TRANSFER/DUE AMOUNT OUTSTANDING] which should be .0056 per month if less than 1000.00 but if more than 1000 it should be .01.  Can you help me with this?

Thank you for your assistance.

Answer 4

Hi Terry X,

It didn't render the results that I need.  I am trying to recalculate the interest for [TRANSFER/DUE AMOUNT OUTSTANDING] which should be .0056 per month if less than 1000.00 but if more than 1000 it should be .01.  Can you help me with this?

Thank you for your assistance.

Hi,

I see... Let's try it without worrying about the Round() function first. So, how about?

INTEREST: [TRANSFER/DUE AMOUNT OUTSTANDING] * IIf([TRANSFER/DUE AMOUNT OUTSTANDING]<=1000,0.0056,0.01)

Hope it helps...