query field for record CONTAINING text

[Guest]

Hi. I'm hoping this is relatively easy. Not an expert here. I'm trying to
create a simple query that returns records based upon whether or not a text
field contains a string of text, rather than matching the text exactly. Any
help?

 

[fredg]

Hi. I'm hoping this is relatively easy. Not an expert here. I'm trying to
create a simple query that returns records based upon whether or not a text
field contains a string of text, rather than matching the text exactly. Any
help?

As criteria on that column....
To find the text anywhere in the field, write:
Like "*" & [Look For?] & "*"

To find the text at the beginning of the field, write:
Like [Look For?] & "*"

To find the text at the end of the field, write:
Like "*" & [Look For?]