query "contains text"

[Mike D.]

This should be a simple one for some -
I'm trying to have a query from a "memo" type field in a
form containing the text asked.

For example - If the memo field has the following
statement:
"I think I can"
I wanted to find results with the word "think", is there
some sort of "*think*" function to get the result?

Thanks,
Mike D.

 

[[MVP] S. Clark]

WHERE fieldname LIKE "*think*"


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-