IIF in query (1 Viewer)

[Pvarga]

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]

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]

IIf(([field1] & [field2] = Null) And ([filed3]<= [field4]),???,"Same")

 

[Pvarga]

Thanks much.