Parameters for Crosstab Query

[damon johnson]

Hi All!

Access 2002 on Win XP Pro

Is there a way to prompt a user to enter parameters for a
crosstab query?

I know it's possible for parameter queries.
I want to base a report on my crosstab query. When the
user attempts to print the report, I would like for a
parameter dialog box to pop up and ask for two parameters.

Thanks,
Damon

 

[John Viescas]

Damon-

Absolutely, but the one trick with crosstab queries is you must explicitly
declare the parameters. When you have the query in Design view, choose
parameters from the Query menu.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

 

[DamonJohnson]

Many thanks John.
However I put in my parameter values, yet the returned
dynaset is not giving the results I requested.
What am I missing?

Thanks again

 

[John Viescas]

Please post the SQL from your query and give me some idea of the purpose of
the query and the parameters.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411