If statement.... like *name*

[Bill]

Hi

I'm trying to make it work but no result...

I try to use like Result: IIf([Field2] like *[Field1]*,"Possible
Match") I couldn't get any result. I need your help if you have answer for
this.

Field1 Field 2
Baseball ball
Wood Holywood

Your help would be much appreciated.
Thanks

 

[Chaim]

Try

Result: IIf([Field2] like "*" & [Field1] & "*", "Possible Match", "Not a
Candidate")

Problem 1 was that the condition was not being recognized as a string.
Problem 2 was that you didn't provide a False choice.


Good Luck!