Query Criteria

[DWSKAMS]

I'm trying to build a query that gives the user the option to pick what they want to search for in a specific column of the table...



Status column contains either "Lost" or "Found"

I want the user to be able to select either lost, found or show them all.

In the Criteria field I am using the current statement [Are you searching for "Lost", "Found" or "both"?]

Searching for lost or found is easy but how can I search for both? I have tried using a wildcard * only, but that doesn't work.

I'm not familiar with code or visual basic, so I am only working with Macros and simple queries.

Thanks for the help.

[June7]

Here is example of dynamic parameterized query method of filtering records: http://datapigtechnologies.com/flash...tomfilter.html