Find out particular word in ms query filed and display result in other filed

premdasp

premdasp
Local time
Today, 12:40
Joined
Jul 7, 2008
Messages
5
iif chek condition.jpg
 
Use the Instr function to search for 'Battery'

Condition:IIf(InStr([Material Details],,"Battery")>0,"Yes","")
 
its now working Sir. Thanks... 🙏
 

Users who are viewing this thread

Back
Top Bottom