Unecxpected results with an IIF statement

Does the below expression have any syntax errors? It's giving me an "n" when
I am expecting an "o"??

=IIF(TRIM(Fields!ITEMNMBR.Value) = "1000" OR "1003" OR "1006" OR "1009" OR
"1012" OR "1015"
OR "1018" OR "1024" OR "1027" OR "1021" OR "2311" OR "2316" OR "2319" OR
"1030" OR "1033"
OR "1034" OR "1035","n","o")

Amarnath
Thu May 24 10:08:01 CDT 2007

It looks different, you cant have just "OR" instead you need to write this
(TRIM(Fields!ITEMNMBR.Value) = ) for each value

Try to prove it wrong first ie try giving "2000" instead of "1000" so it
should return "o" if it returns "o" then this complete expression is wrong
and evaluating just for first value. So yopu can change it.

Amarnath



"Chris Patten" wrote:

> Does the below expression have any syntax errors? It's giving me an "n" when
> I am expecting an "o"??
>
> =IIF(TRIM(Fields!ITEMNMBR.Value) = "1000" OR "1003" OR "1006" OR "1009" OR
> "1012" OR "1015"
> OR "1018" OR "1024" OR "1027" OR "1021" OR "2311" OR "2316" OR "2319" OR
> "1030" OR "1033"
> OR "1034" OR "1035","n","o")