Because = and LIKE are two operators, a little bit like:

4 * / 3

would mean what (multiply followed by divide)?

Probably better to remove the =, in this case:

BUSH: IIF(PartDesc Like *BUSH*, "yes","no")


Vanderghast, Access MVP


"Cam" wrote in message
...
Hello,

I have the following field in the query to look at a field PartDesc, if
any
of the text have a *BUSH* word, return yes, otherwise no.
BUSH: IIF(PartDesc= Like *BUSH*, "yes","no")

Why the Like *BUSH* not working? Thanks