IIF in Query Design



I created a query based on query. I am creating a new field in the
query called "Series". The field is created as follows:

Series: IIf([ITEM_NBR] Like "11-2*","11-2XX")

For all ITEM_NBR that are 11-201 or 11-202 etc make the value in the
Series field 11-2XX. This works fine. The problem is when I try to
add a 2nd part to this expression such as:

Series: IIf([ITEM_NBR] Like "11-2*","11-2XX") Or IIf([ITEM_NBR] Like
"11-3*","11-3XX")

This query runs but instead of putting a value of 11-2XX or 11-3XX in
the Series field I get a -1 for everything that should be 11-2XX or
11-3XX.

I have tried many different variations on this with no success. Any
help would be greatly appreciated.

bshort1023

.