Query to produce boolean

[PG2015]

Can anyone help me with this?

Produce a query that returns a yes or no (Y or N) field if other text field contains particular text (with wildcard on either side).

Idea is to have a column for each preset word.

Hope that makes sense, Access newbie :banghead:

 

[pr2-eugin]

Hello PG2015, please give some sample. The simplest would be.

NewColumn: IIF(InStr(theField, "theValue") <> 0, "YES", "NO")

 

[PG2015]

Brilliant, brilliant - thanks for your help! Works a treat.

Cheers