IIF Statement

[Guest]

Hi,

I am trying to write an IIF statement. I want to check the "Type" and
"Fund" fields for specific data and return a "Platform". If the Type equals
"X" and the Fund begins with 2 through 5, I want to have the Platform field
return "P". If the Type equals "X" and the Fund begins with a 7, I want to
have the Platform field return "U". If neither are true, I want the Platform
to return "None".

Any help will be greatly appreciated.

 

[Ken Snell \(MVP\)]

Perhaps

Platform: IIf([Type]="X", IIf([Fund] Like "[2-5]*", "P", IIf([Fund] Like
"7*", "U", "None")), "None")