parameter value all

[joe789]

Hello folks,

Any help of this question would be very greatly appreciated. I am trying to create a query that utilizes parameter values. If I assume that a user runs the query and receives a number of user prompt boxes (parameter value) for what selection criteria they would like to use when displaying the data they would like returned from the query.

If a user does not want to supply a value for one of the parameter queries, how can I make it so that the query will still run and simply return the data that the user specifies in the parameter values while returning all options for the parameter values the user does not which to choose.

Is there some word such as 'ALL' or something that a user can type in a parameter value prompt box to not filter that value but to show all options for that field in the query?

Is this possible?

Thank you very much,

Joe

 

[Jack Cowley]

Creating a query as you described in your post is difficult to do. I would suggest you use Query By Form using Dynamic QueryDef and the article you will find here will show you how to do that...

hth,
Jack