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

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

Put that where?

Thanks for the reply,

JO

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.