Parameter query
 

I am just wondering if it is possible to use a parameter query with either a
union query or an external pivot table? Can this be done?

Parameter query
 

From an Access standpoint yes you can do a parametric query in a union query.
The where clause in each of the select statements should reference the same
parameter. With respect to doing parametric query with a pivot table, that is
an official "no can do" according to the microsoft website...

HTH

"mtate" wrote:

I am just wondering if it is possible to use a parameter query with either a
union query or an external pivot table? Can this be done?

Parameter query
 

mtate

For parameters in pivot tables, see here

http://www.dicks-blog.com/archives/2...le-parameters/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

mtate wrote:
I am just wondering if it is possible to use a parameter query with
either a union query or an external pivot table? Can this be done?