Table list in CrossTab Pivot statement

B

Biggles

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
 
D

Duane Hookom

"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.
 
Top