Need help for search function in access

[dnyanpawar26]

Hello Team,

Please assist me to update the below criteria in my query.

=IFERROR(IFERROR(IF(SEARCH("ProcessI",B2)>0,"Process Active"),IF(SEARCH("ProcessC",B2)>0,"Process Completed")),"Process Not Active")

As i am not able to update the same in current query.

 

[Joe4]

Try:

IIf(InStr([FieldName],"ProcessI")>0,"Process Active",IIf(InStr([FieldName],"ProcessC")>0,"Process Complete","Process Not Active"))

where [FieldName] is the name of the field you are searching.

 

[dnyanpawar26]

Thanks joe, i will try it.

Appreciate for your help.