How can I filter to A PART of the value?
Let’s say the field values are
“One Alpha”
“One Beta”
“Two Alpha”
“Two Gamma”
and I would like to find all values CONTAINING “One”
I know the Operator “InList” (see example below):
=If([Query1].[Field1] InList("One Alpha";”One Beta”;"okay”;”Not Okay”)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.