Ad Hoc Query

[jneirinckx]

Good Morning,

I have been asked to provide/create a simple query that the user can choose what he wants to filter from the data. I have searched the forum but with no results.

Any thoughts or suggestions on how I would approch this.

Thanks

Jerry

 

[stopher]

I assume you are using the query design grid. You can add an expression into the criteria of one or more of the fields that will prompt the user to enter a value.

Suppose you have a query with a field called location. In the criteria box underneath location, type:
[Enter required location]
or whatever suitable description you choose. Then run the query.

You can add more prompts under different fields.

hth
Stopher

 

[jneirinckx]

Thank You

I'll try that.

Jerry