Save queries to create pivot table templates

[peter]

Dear all,
I have an existing query called 'A', but I want it to view in Pivot
Table.

What I do is :
- Double click the query and choose Pivot Table view.
- I make some changes by adding some fields to the pivot table.
- Next, I want to save these setting as a new query. (Because I know
that
multiple templates may be needed to keep track as user has change the
setting.)

My question is how to save these settings into multiple new queries?

Regards,
Peter

[AP]

Hey Peter

Check out this program www.megacrosstab.com. It is an Access Add-in
that gives you similar functionality of a pivot with the ability to
save the output as table or query. There is also the ability to save
the configurations for multiple versions.
Thanks
AP

peter wrote:

Dear all,
I have an existing query called 'A', but I want it to view in Pivot
Table.

What I do is :
- Double click the query and choose Pivot Table view.
- I make some changes by adding some fields to the pivot table.
- Next, I want to save these setting as a new query. (Because I know
that
multiple templates may be needed to keep track as user has change the
setting.)

My question is how to save these settings into multiple new queries?

Regards,
Peter