multiple nested IF Statements

[Frederick_13]

Hi all,

i am trying to build this: 

      IF (Invoice.[MID_TERM]. values[7] = 'N') THEN

             IF (Invoice.[ BUSINESS_TYPE].values[8] <> 3) THEN

                        IF (Invoice.[ PERIODIC_INVOICE_FLAG].values[18] <> 'N') THEN

                                    Invoice.[MID_TERM]. values[7] = 'Y';

                        ELSIF (abs(Invoice.[ RENTAL_DAYS].values[10]) >= longterm_limit) THEN

Invoice.[MID_TERM]. values[7] = 'Y';

                                               END IF;

                                    END IF;

                               END IF;

but I end up with an error at the end of nested IF Statements. Nothing works neither one "END IF" nor 2 or 3. Could you please help me out?

  thx

[Qiu · Accepted solution]

@Frederick_13 
IF ELSE ENDIF should all presented to close the conditional statement.
One more thing I have noticed that it seems you want to overwrite the value for Column "LONG_TIME" while you are using Boolean statement, whch results 0 or 1.

[Frederick_13]

thx for your help and your remark about the Boolean. Indeed I had to change data type

[Qiu]

@Frederick_13 
Good to know it helped. 😁