By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,282 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Pivot Tables

bhcob1
P: 19
Hi guys,

I need to create a Pivot Table on my database, I don't know much about them. I want the user to be able to direct themselves from my main switchboard (via a cmd button) to the pivot table. Where is it best to create a pivot table VBA, Form, Page... I would like the Pivot Table to not save the users changes but instead open up as a defualt that i set.

So I guess my question is, where is the best place to create a Pivot Table for the user. Also once the user has used the pivot table to manipulate to the data they want, what is the best way to copy it to a flat table in excel.

Cheers
Feb 9 '07 #1
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,599
Hi guys,

I need to create a Pivot Table on my database, I don't know much about them. I want the user to be able to direct themselves from my main switchboard (via a cmd button) to the pivot table. Where is it best to create a pivot table VBA, Form, Page... I would like the Pivot Table to not save the users changes but instead open up as a defualt that i set.

So I guess my question is, where is the best place to create a Pivot Table for the user. Also once the user has used the pivot table to manipulate to the data they want, what is the best way to copy it to a flat table in excel.

Cheers
In the Database Window
__1 Select the Forms Tab ==> New ==> Pivot Table Wizard
__2 Select a Data Soure ==> OK
Feb 9 '07 #2

P: 14
Is there a difference between a pivot table generated directly from a query
to a pivot table generated from a form that is based on a query?
Feb 9 '07 #3

NeoPa
Expert Mod 15k+
P: 31,186
Can you even do that (Base a Pivot-Table on a Form)?
Feb 10 '07 #4

P: 14
Uhh....I meant using a form to make the pivot table........but the form will still be based on the query.
Feb 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.