Access nested IIF's

[haydenbl]

I have looked at this statement too long and still can't figure it out. I know it's something easy, but I just can't see it. I get the error statement "The expression you entered has a function containing the wrong number of arguments."

This is my IIF statement:

UserState: Left(Trim(IIf([Temp10] Like "*NEW USER'S REGION*",
Trim(Replace([Temp10],"NEW USER'S REGION:","")),
IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRA*",
Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FRA>>","")),
IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRAC-FRA*",
Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FRAC-FRA>>","")))),2)



Thanks for your help.

 

[OBP]

It is a tricky one without actually building it, but it looks as if you have 8 Right Hand ( and 9 Left Hand )

 

[Chawbacon]

Hello Haydenbl,

It appears that you have three independent IIF statements instead of one Nested IIF statement in your expression. This observation is based upon the non-quoted comma placement. Therefore, having three independent arguments, Access throws up the wrong number of arguments error.

UserState:
1. Left(Trim(IIf([Temp10] Like "*NEW USER'S REGION*",
Trim(Replace([Temp10],"NEW USER'S REGION:","")),

2. IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRA*",
Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FRA>>","")),

3. IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRAC-FRA*",
Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FRAC-FRA>>","")))),2)

You could try a variation on the following: (I have not checked this... Just a quick modification idea)

UserState: Left(Trim(IIf([Temp10] Like "*NEW USER'S REGION*",
Trim(Replace([Temp10]"NEW USER'S REGION:")),
IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRA*",
Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FRA>>"),
IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRAC-FRA*",
Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FRAC-FRA>>)",")))

I hope this helps,

Chawbacon