G
Guest
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
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