IIF in Query Design
- From: bshort1023@xxxxxxxxx
- Date: 28 Feb 2006 08:34:15 -0800
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
.
- Follow-Ups:
- Re: IIF in Query Design
- From: james.igoe@xxxxxxxxx
- Re: IIF in Query Design
- From: tina
- Re: IIF in Query Design
- Prev by Date: Re: Conversion of an MS Access application
- Next by Date: Re: IIF in Query Design
- Previous by thread: Run-time error '6' Overflow
- Next by thread: Re: IIF in Query Design
- Index(es):