IIF function help in query

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

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
 
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
 
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
Click to expand...

You cannot use = Like. Use either = or Like.
You also need to enclose the criteria value within quotes.

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

The above should fine all records that contain the letters "BUSH"
anywhere in the field, i.e. "Bush", "Bushmill", etc.

if you wish just the word "Bush" to be returned, use Like "* Bush *"
 
Back
Top