471,573 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

Save queries to create pivot table templates

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

Jul 10 '06 #1
1 3146
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
Jul 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Robert | last post: by
2 posts views Thread by Rob | last post: by
4 posts views Thread by Ajay | last post: by
2 posts views Thread by Gary Dunne | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.