How to search the records for a particular word in a field in MS access?

How to search the records for a required word in a field in MS access through q开发者_运维问答uery or forms?

Considering you provided limited info you do the following:

SELECT column
FROM Table
WHERE column.value like "*word*"

If you are looking for the part of the word, you use a * in either the front/end of the value. It is your wildcard that allows you to find the word.

If you are looking for an exact word, you would just search directly for the word:

SELECT column
FROM Table
WHERE column.value = "word"

If you want to exclude records then:

SELECT column
FROM Table
WHERE column.value <> "word"