Keyword search (1 Viewer)

[dcarr]

If I had a table with a column named keyword. An for each row within the table in the column keyword I had more than one word such as computer networks, tcp ip, ETC. How would I construct a query to find a match on any of the data and not just the first item in the column?

 

[Shep]

In query design view, in the Criteria row:

Like "*tcp*"

This is only an example. Use asterisks on both sides of the search text to find every instance of the string in all records of the field.

If you wish to do a left or right-hand only search, omit the appropriate asterisk.