If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table list in CrossTab Pivot statement
There might be an eaiser way to do this, but I am in a hurry and have
existing queries I need to fix. I have a crosstab query where the column headings are derived from a table. I would rather not have to type in all the values of that table into the IN clause(although there are only 10 or so), since those values might change. Is it possible to use that as a source for the IN statement of the PIVOT clause of my crosstab? Thanks -- Fictionally Yours, Biggles |
#2
|
|||
|
|||
Table list in CrossTab Pivot statement
"Is it possible to use that" what do you mean by "that"? You can't use a
table or select statement in the IN () clause of a crosstab query. You can use DAO code to dynamically build your SQL statement and apply it to the saved crosstab QueryDef. -- Duane Hookom Microsoft Access MVP "Biggles" wrote: There might be an eaiser way to do this, but I am in a hurry and have existing queries I need to fix. I have a crosstab query where the column headings are derived from a table. I would rather not have to type in all the values of that table into the IN clause(although there are only 10 or so), since those values might change. Is it possible to use that as a source for the IN statement of the PIVOT clause of my crosstab? Thanks -- Fictionally Yours, Biggles |
Thread Tools | |
Display Modes | |
|
|