M Michel Walsh Jun 13, 2005 #2 Hi, To the contrary of a crosstab, a pivot table is a dead end and cannot be further used in another SQL statement. Try to build the SQL statement that combines your data and then, make the crosstab. Hoping it may help, Vanderghast, Access MVP
Hi, To the contrary of a crosstab, a pivot table is a dead end and cannot be further used in another SQL statement. Try to build the SQL statement that combines your data and then, make the crosstab. Hoping it may help, Vanderghast, Access MVP
