Building Search Tool - How to filter on the principle of "Contains

[BlueWolverine]

Hey,
Running Access 2003 on XP Pro.

Say I have a form based on a query based on a table. The Form shows all
records in the table unless the query is restricted obviously.

I want the user to be able to restrict the query in a way similar to auto
filters in EXCEL.

If all I can get is the ability to filter on "CONTAINS XXX" then that works
well enough.

Ideas?

 

[John W. Vinson]

Hey,
Running Access 2003 on XP Pro.

Say I have a form based on a query based on a table. The Form shows all
records in the table unless the query is restricted obviously.

I want the user to be able to restrict the query in a way similar to auto
filters in EXCEL.

If all I can get is the ability to filter on "CONTAINS XXX" then that works
well enough.

Ideas?

Try a criterion such as

LIKE "*" & [Enter search term:] & "*"

or for a literal search string,

LIKE "*XXX*"