Find out particular word in ms query filed and display result in other filed
isladogs MVP / VIP Local time Today, 11:17 Joined Jan 14, 2017 Messages 18,261 Jul 19, 2020 #2 Use the Instr function to search for 'Battery' Condition:IIf(InStr([Material Details],,"Battery")>0,"Yes","")
Use the Instr function to search for 'Battery' Condition:IIf(InStr([Material Details],,"Battery")>0,"Yes","")
P premdasp premdasp Local time Today, 14:17 Joined Jul 7, 2008 Messages 5 Jul 19, 2020 #3 its now working Sir. Thanks...
isladogs MVP / VIP Local time Today, 11:17 Joined Jan 14, 2017 Messages 18,261 Jul 19, 2020 #4 You’re welcome