none
You have entered an operrand without an operator RRS feed

  • 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?
    Wednesday, August 16, 2017 6:00 PM

All replies

  • 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...


    • Proposed as answer by Terry Xu - MSFT Thursday, August 17, 2017 3:11 AM
    • Edited by .theDBguy Thursday, August 17, 2017 4:55 PM
    Wednesday, August 16, 2017 6:15 PM
  • Thank you very much.  I will try.
    Thursday, August 17, 2017 12:46 PM
  • 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.

    Thursday, August 17, 2017 4:46 PM
  • 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...

    Thursday, August 17, 2017 4:54 PM