Hi, I use Access97. I created a Pivot table on a Select query. I want to use this Pivot table as my template and create more pivot tables on some other select queries. The field names in these queries are exactly the same. Can I do that? And how? Thanks a bunch.