Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I want to return any and all occurrences of the word "modified" in a particular field; ie, "modified by client", or "this has not been modified" or "we have been asked to modify" would all be found and displayed

What expression is required in the Criteria box in the Query Builder

Thank

Rick Kania
 
I have a query that I want to return any and all occurrences of the word "modified" in a particular field; ie, "modified by client", or "this has not been modified" or "we have been asked to modify" would all be found and displayed.

What expression is required in the Criteria box in the Query Builder?
Click to expand...

The word "modified" does not occur in the text string "we have been
asked to modify", and Access - unlike some "Textbase" software - isn't
knowlegable about English regular (or irregular) verb forms.

You could use a criterion of

LIKE "*modif*"

which might get some false drops (i.e. "the client insists that this
must be left unmodified") but it should get all of the ones you asked
for. The LIKE operator recognizes wildcards; * is a wildcard meaning
"any text string".
 
Back
Top