| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parameter query in MS Query from Excel | Excel Discussion (Misc queries) | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| parameter query help | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
