Find vs Querying

[joltremari]

I have a field with a brief description such as: New sec and ser

If I use "Find" and choose "Any part of field" every time I click "Find Next" it will find any one of those words I choose.

How can i make a query do the same..

JO

 

[David R]

"*" & [Enter as much as you know] & "*"

 

[joltremari]

Put that where?

Thanks for the reply,

JO

 

[David R]

Either in the WHERE clause of your SQL statement, or in the criteria section of the query, depending on how your search box is structured.