My query is a simple query but I can't get the right filter to work. In one of my columns I have "Consent and Regulatory" in the text column.
I have tried: Like "*Consent*" and returns anything with consent in that column which is great but I also want the choice to select "Regulatory" to return any record with regulatory in it. I rather not have to create a second query to do that. I like to have a popup screen so I can type in one or the other. I have tried "And" and "Or" statements and I can't get them to work in the criteria section.
I hops this makes sence.