Query looking for a word in a Text field

[Albert1955]

I am trying to make a query that looks for a particular word in a text field, and gives me a list of people with that word only
I work in a community organisation so I dont have much training, so its probably an easy way to do

thanks for any help
A

 

[John Big Booty]

You can use criteria in the following form;

Like "*Your Text String*"

To search any portion of your text field for the string "Your Text String". If you remove the leading asterisk the query will only return a string that starts with the phrase and likewise removing the trailing asterisk will return only string that end with that phrase.

The sample here may also be of interest to you, as it uses this principal to dynamically search a number of fields for a text string match.

 

[Albert1955]

Thanks a billion
it works just the way i wanted it too
I will remeber Like for next time
thanks again
A