Query one word in a description

[Guest]

I am trying to make a query for orders that I enter daily for a monthly
report. I have certain items that need to be included, however, the one I am
having trouble with is querying a single word for the description of an
order. For example, I need the word "upgrade" from a description such as
"Upgrade vrom V2 to V3" This description is in a sub-category. This is a
database that was created by another person who is no longer with the company
and I am having many problems since the relationships go to many, some not
even useful. I need this query to make a monthly sales report and have this
question before I can even begin to start making the report.
Sarah

 

[Ken Snell [MVP]]

Search for a word within a text string via these methods:

(1) The word is at the beginning of the text string:
Like "Word" & "*"

(2) The word is at the end of the text string:
Like "*" * "Word"

(3) The word can be anywhere within the text string:
Like "*" & "Word" & "*"