Search for text string in a query field 1

[KamikazeMoth]

I want to search a text field in a query, for a certain keyword.

EG : The brown dog sat on the cat (search : brown)

All I can come up with is the LIKE operator, but I have to put in the whole text string, which I don't know and isn't always the same.

Any ideas (am using Access2000)

cheers

 

[BobAtHome]

Add a column to the query and put this in it. Since I don't know the name of your text field, I will just use a field called - TextFieldName.

MyWord: InStr([TextFieldName],"brown&quot

and in the criteria for that column put in:

>0

The InStr function will look for an occurance of the word in the field. If it finds the word, it will return the start position of the word. If it doesn't find the word in the text string, then it will return a 0 (zero).

So if the returned value is greater than 0 (zero), then the text string contains the word.