IIf with Or - Why?

dschomburg · Apr 2, 2001

Can someone please tell me why this does not work. What would be the correct syntx.

=IIf(Or([DNIS]=2250,[DNIS]=3110),"Lease","Loan&quot

Any Help would help a heap.

Thanks,

Dave

LarryDeLaruelle · Apr 2, 2001

Dave:

I think what you need is:

=IIf([DNIS]=2250 OR [DNIS]=3110,"Lease","Loan&quot

That should do it.
Larry De Laruelle
larry1de@yahoo.com

dneufarth · Apr 2, 2001

Access does not have the OR function as does Excel. Compound conditions are handled as Larry has demonstrated above.

Dave

dschomburg · Apr 2, 2001

Far Out! Groovy! Hip! Solid! Right On!
That worked great!