Create several pivot table for one table

[OldManExcellor]

In Access I know that I can create a pivot table for a data table by right clicking the table tab and choosing the pivot table view.

This way I can create one pivot table connected to one "data table".

Is there any way to create several pivot tables all connected to one data table?

For example I might use three pivot table views often and instead of pulling data here and there I would like to be able to view all three of them in different tabs.

 

[SydneyGeek]

Create 3 forms based on the table. Change each to PivotTables; then you can build different views, one per form

Denis