Pivot Tables

[bhcob1]

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

[ADezii]

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

[kaykae]

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?

[NeoPa]

Can you even do that (Base a Pivot-Table on a Form)?

[kaykae]

Uhh....I meant using a form to make the pivot table........but the form will still be based on the query.