Query for text within a large text field

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

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.
 
Dan said:
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.
Click to expand...


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*"
 
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.
 
Back
Top