View Full Version : IIF in query


Pvarga
05-23-2002, 05:05 AM
How can I use more than one IIf

I want to have it enforce that 2 different cols are Null and use ,= on a third col.

I seem to get only 2 out of 2 working because I must be typing it wrong. I tried And

I want it like IIf([field1] And [field2] Is Null And[filed3]<= [field4],"Same")

I know that is wrong but it is as close to showing what I need.

Thanks

Tricia

Fizzio
05-23-2002, 05:20 AM
I'm not quite sure what you are trying to achieve but try this

IIf([field1] Is Null And [field2] Is Null And[field3]<= [field4],"Same")

llkhoutx
05-23-2002, 11:01 AM
IIf(([field1] & [field2] = Null) And ([filed3]<= [field4]),???,"Same")

Pvarga
05-23-2002, 04:42 PM
Thanks much.