condition not working

Can any one correct me on this.

Actionoverall: IIf([actiondirectors] Is Null,[action],[actiondirectors],iif([action]="declined",[actiondirectors]))

It says, wrong number of arguments.

Rishy

Rishy,

The IIf statement can only have three arguments. (Condition, True, False)

So what you want is the following,

If [actiondirectors] = Null, Then the TRUE part will be [action] and the FALSE part will be [actiondirectors].

Your next statement If [action] = "declined" Then the TRUE part will be [actiondirectors], but no FALSE argument was given. I assume it will be [action].

So it would look something like this:

IIf(([actiondirectors]=Null,IIf([action]="declined",[actiondirectors],[action]),[actiondirectors]))

Work with the syntax, as I did not test the conditions.

lwells