haydenbl
Thread Starter
- Joined
- Jul 6, 2018
- Messages
- 1
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.
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.