Criteria using a partial match to a text field

[endwarde]

Hi there,
I am sure this is simple, I am just not finding the answer anywhere. I am trying to create a query where I have a user definable criteria which searches for matching text within a text field.

For instance, the actual text field entry may read:
"Ghana field reports"

and I wish to have the user be able to enter just:
"Ghana"

and have it return the record above with the word "Ghana" (as well as any other records with Ghana in it) in the query.

I am doing this by just putting in the simple [Enter Description], but unless I put in text which matches the field exactly, I don't get anything.

So, is there some way of writing this so a user use a criteria to show records based on text within a field? Or am I thinking about this all backwards?

 

[PHV]

Like '*' & [Enter Description] & '*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[endwarde]

Excellent. This works great. I tried a number of different combonations very similar this, but never tried that one.

Thanks!