Query and Contains filter

[Roger L.]

I am attempting to write a query where the filter uses the
Contains operator. What syntax, if any, do I use in the
data field related to the 'contains' operator? I want to
enter AD and VO so that only records that contain those
values in a certain field are chosen. Or do I have to
use 'equal' along with 'or'? Thanks.

 

[Dave Peterson]

If you record a macro, you'll see the syntax.

And if you notice the syntax, you might be surprised that you can use that via
the userinterface.

Equals *AD*

(I find typing leading and trailing asterisks easier than scrolling down to
Contains!)