I'm sure this will be pretty easy for most of you but I'm stuck.
I have a crosstab query and I want to filter out entries that do not contain a string of text. I'm used to using "like" in the criteria to find matching fields to the string but that doesn't work when I want anything that at least contains the string...
I.E. I have a field in the query called Plan. I only want entries that at least contain "FL" OR "STRAT" in Plan. So I put Where in the total spot but I have no idea what I should put in the criteria spot since every formula I try to make errors out.
So, what should I use? Is there a function as easy as like that I can use?
I have a crosstab query and I want to filter out entries that do not contain a string of text. I'm used to using "like" in the criteria to find matching fields to the string but that doesn't work when I want anything that at least contains the string...
I.E. I have a field in the query called Plan. I only want entries that at least contain "FL" OR "STRAT" in Plan. So I put Where in the total spot but I have no idea what I should put in the criteria spot since every formula I try to make errors out.
So, what should I use? Is there a function as easy as like that I can use?
