Rodney,

The Remedy Helpdesk 3.0 templates do a lot of this with the shared reporting
schema. Basically, the way you would have to do it is to record a macro
that performs a query. In the "Query:" line at the bottom of the query
window, you would place a variable parameter (e.g., $InsertQueryHere$).
When you go to run the macro, you will be prompted for the qualification
criteria.

I do this alot when I'm building dynamic queries for applications. The only
down side is that you will have to provide a place for your user to enter
the data they want to be passed to the macro because running the macro from
an active link will not prompt the user for the parameter values.

Hope this helps.

Derek
------------------------------------------------------------
Derek Berube, CIO
Venimex Consulting Services, Inc.
1530 Dunwoody Village Court
Suite 130
Atlanta, Georgia 30338
http://www.venimex.com/
770-730-9847
770-730-9856 FAX




-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.ACSU.BUFFALO.EDU]On Behalf Of Rodney Lynxwiler
Sent: Friday, January 08, 1999 1:21 PM
To: ARSLIST@LISTSERV.ACSU.BUFFALO.EDU
Subject: Parameter Queries


Does anybody know how to make a parameter query (where you are asked for
the criteria each time you run the query) on a list box field? Thanks.

Rodney

Rodney,

Maybe you could have an additional field that is read into the query to
produce the list box field?

Cheers,
Matt.

Rodney Lynxwiler wrote:

> Does anybody know how to make a parameter query (where you are asked for
> the criteria each time you run the query) on a list box field? Thanks.
>
> Rodney

Does anybody know how to make a parameter query (where you are asked for
the criteria each time you run the query) on a list box field? Thanks.

Rodney