Setting up parameter query’s

[Calvin3457]

I have a text field in my query that i would like to modify with a parameter that will allow several choices or wildcards. For example, in the criteria i would like the parameter to read:



[parm AND parm AND....]

so, it would be this way

[dogs AND cats AND birds]. It would allow multiple words or phrases, as needed

[June7]

I doubt any record can meet that criteria. A field has only one value, so how could a record meet requirement of 3 values? Maybe you want OR operator.

Show example of raw data and desired output.