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
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