Using an OR statement in IIF

D

David Lloyd

Billy:

You can use an OR clause in an IIF statement, however, you need to write a
complete statement for each OR alternative. For example:

(IIf((Left([TRACKINGNUMBER],2))="88" OR Left([TRACKINGNUMBER],2)="27" OR
Left([TRACKINGNUMBER],2)="51","http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber="
& [TRACKINGNUMBER],"test"))



--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Is it possible to use an OR statement in an IIF? e.g.

Expr1: (IIf((Left([TRACKINGNUMBER],2))="88" OR "27" OR
"51","http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=" &
[TRACKINGNUMBER],"test"))

this doesn't seem to work and I already have 3 IIF embedded in one
statement.
 
Top