Criterior question

[MM33]

How can I set a criterior to retrieve data that contains the charachers of the specified criterior. for example:

row description
1 Bank rtr Train
2 Deutche bnk Training
3 RTR training

I want to set a criterior to get all the data listed above.
I need to set the criterior to look for "Train", however this does not seem to give me the data. Any help on this would be much appreciated.

rgds

 

[Rhonin]

I am assuming you are doing this with a query.

In the Criteria line for the field [Description] type:
Like "*"&[Enter key word: ]&"*"
This will display all of the above entries if you type in the work "train" in the vb box that is displayed when you run the query.

Example ( I ran the following SQl and typed in "Train" when prompted)

SELECT Table1.Row, Table1.Description
FROM Table1
WHERE (((Table1.Description) Like "*" & [ Enter key word: ] & "*&quot);


My results were:
Row Description
1 Bank rtr Train
2 Deutche bnk Training
3 RTR training