Hi All,
I am a new member on this site. Could you please help on this problem.
For the selected vendors:
A) if at least one of the indicators LOEVM, SPERR, or SPERM ="X", set COMPANIES.DISABLED to "1"
ELSE
B) If SPERQ = one of the values below:
PA (Vendor Moved)
PD (Block for Duplication)
PE (Block for Commercial Issue)
QF (Disapproved)
QG (Inactivated)
QH (Unapproved)
set COMPANIES.DISABLED to "1"
ELSE:
C) set COMPANIES.DISABLED to "0".
I tried with
"IIf([LOEVM]="X" and [SPERQ]="PA" or "PD" or "PE" or "QF" or "QG" or "QH",1 Or 0,IIf([SPERR]="X" And [SPERQ]="PA" or "PD" or "PE" or "QF" or "QG" or "QH",1 or 0,IIf([SPERM]="X" And [SPERQ]="PA" or "PD" or "PE" or "QF" or "QG" or "QH",1,0)))
"
didn't work.
Thanks.
I am a new member on this site. Could you please help on this problem.
For the selected vendors:
A) if at least one of the indicators LOEVM, SPERR, or SPERM ="X", set COMPANIES.DISABLED to "1"
ELSE
B) If SPERQ = one of the values below:
PA (Vendor Moved)
PD (Block for Duplication)
PE (Block for Commercial Issue)
QF (Disapproved)
QG (Inactivated)
QH (Unapproved)
set COMPANIES.DISABLED to "1"
ELSE:
C) set COMPANIES.DISABLED to "0".
I tried with
"IIf([LOEVM]="X" and [SPERQ]="PA" or "PD" or "PE" or "QF" or "QG" or "QH",1 Or 0,IIf([SPERR]="X" And [SPERQ]="PA" or "PD" or "PE" or "QF" or "QG" or "QH",1 or 0,IIf([SPERM]="X" And [SPERQ]="PA" or "PD" or "PE" or "QF" or "QG" or "QH",1,0)))
"
didn't work.
Thanks.