Problem!

[star777]

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.

[isladogs]

Cross posted at https://www.access-programmers.co.uk...=1#post1584687

Please read this link about the etiquette of cross posting https://www.excelguru.ca/content.php...-cross-posters

[June7]

IIf(LOEVM = "X" Or SPERR = "X" Or SPERM="X" Or SPERQ IN("PA","PD","PE","QF","QG","QH"), 1, 0)