find single word in multiple word field

[denisedosp]

I posted to the wrong forum, so now I am posting again here.
I need to return a list of records based on finding one or two words in a field containing phrases. I have tried many SQL statements with no luck. I cannot use find and find next, as I need a view of ALL records fitting the criteria.
Does anyone have an SQL statement to accomplish this?
Thanks
Denise

 

[SgtJarrow]

Try:

SELECT [Fields]
FROM

WHERE (((

.[Field]) Like "* word *&quot);


****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com

 

[denisedosp]

I don't know you but I think you are wonderful!!!!! It worked. I went back and forth with * and " before not both. hahahahahaha
ciao and thanks
Denise