Query for text within a large text field

[Guest]

I just need a simple way to lookup records for a report based on a keyword
within a large text field used to describe events that took place.

The "Like" criteria will not work since the word I would be keying on will
not be the first word in the field.

If possible I would like a way to accomplish this from the QBE since I am
SQL illiterate.

Thank you.

 

[Marshall Barton]

I just need a simple way to lookup records for a report based on a keyword
within a large text field used to describe events that took place.

The "Like" criteria will not work since the word I would be keying on will
not be the first word in the field.

The Like operator will do this. You just need to use the
wildcard characters appropriately.

In this case, you want something like this criteria:

Like "*Cancel*"

 

[P Talbot]

Another possibility would be: Like "*" & [Enter a keyword] & "*"
Copied and pasted into the criteria for your text field, this would
generate a prompt for a keyword.