Hello,
A column in one of my tables has a lot of text. It is a “description” field.
I would like the ability to create a query based off of logic relating to
what text is contained in this field.
Here is an example of some of the logic (using colors as an example):
-Color is “red” or “blue” and “black”
-Cannot have colors “green”, “yellow”, ”purple”, “pink”, “brown”, “teal”
I am unsure of how to write this in the “criteria” section of the
“description” field in my query. I’ve tried multiple times with no success.
Any assistance is appreciated!!