Ally
Registered User.
- Local time
- Today, 15:29
- Joined
- Sep 18, 2001
- Messages
- 617
I have a very long IIf statement - thought I'd try the first part before going any further to make sure I'd got all the syntax right ... and found that it's wrong already.
I am using "Not Is Null" and "And" and for some reason (which I know is probably staring me in the face), I cannot get it right. There is only one argument because it's followed by another IIf (there will be 4 in all).
=IIf(Not IsNull([ErrorCat]) And (IsNull([OtherErrors]),[ErrorCat],IIf(IsNull([ErrorCat]) And (IsNull([OtherErrors])," "))))
I am using "Not Is Null" and "And" and for some reason (which I know is probably staring me in the face), I cannot get it right. There is only one argument because it's followed by another IIf (there will be 4 in all).
=IIf(Not IsNull([ErrorCat]) And (IsNull([OtherErrors]),[ErrorCat],IIf(IsNull([ErrorCat]) And (IsNull([OtherErrors])," "))))