Using an IIf statement to search a field for contents

[ajochung]

Hey,

I need to use an iif statement to search a field (column) for a certain word. The field is in tblEquipmentName and the input is in tblWorkReport

Ex.

iif(input from tblWorkReport is in field from tblEquipmentName,...,...)

Thank you

 

[Mihail]

Hey,

I need to use an iif statement to search a field (column) for a certain word. The field is in tblEquipmentName and the input is in tblWorkReport

Ex.

iif(input from tblWorkReport is in field from tblEquipmentName,...,...)

Thank you

Generally you should use the InStr function.
IIF(InStr(...)>0,FoundedTheWord,NotFoundedTheWord)

What I can't understand is how the "input" is in a table ?
In my mind, a table has many records. So... many "inputs" ?!?!?!?