User Profile

haydenbl

Last Activity: Jul 11 '18, 01:28 PM

Joined: Jul 10 '18

Location:

haydenbl started a topic Wrong number of arguments with nested IIF's

in Access

Jul 10 '18, 06:08 PM

Wrong number of arguments with nested IIF's

Code:

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-FSA*",
  Replace([Temp9],"NEW USER'S LOCATION INFO: USA-FSA>>","")),
IIf([Temp9] Like "*NEW USER'S LOCATION INFO: USA-FRAC-FRA*",
  Replace([Temp9],"NEW USER'S LOCATION INFO: U

...

See more | Go to post

Last edited by zmbd; Jul 10 '18, 06:40 PM. Reason: {z: placed required code tags}

No activity results to display

Profile Sidebar

Wrong number of arguments with nested IIF's