Can we merge two pivot table into one by using queries in access datab
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
