Invalid Procedure IIf Statement 2

[dan08]

I am trying to run this If statement in a query.

IIf(InStr(1,[CandidateTypeE],"Dele")>=1,"Delegate",
IIf(InStr(1,[CandidateTypeE],"Faci")>=1,"Facilitator",
IIf(InStr(1,[CandidateTypeE],"Observer")>=1,"Observer","Ungrouped")))
AS CandidateTypeX


And I keep getting an Invalid Procedure Call error.

Any suggestions?

 

[PHV]

What about this instead ?
IIf([CandidateTypeE] Like "*Dele*","Delegate",
IIf([CandidateTypeE] Like "*Faci*","Facilitator",
IIf([CandidateTypeE] Like "*Observer*","Observer","Ungrouped")))
AS CandidateTypeX

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dan08]

Beautiful. Thanks PHV