Can we create multiple pivot tabel views for a singleaccess query?

  • Thread starter Thread starter preeti p
  • Start date Start date
P

preeti p

For an access query there is an option to design pivot table using pivot table view. Now I want to create multiple such views for the same query. Is it possible or do I need to copy this query again into new query to create different pivot table view?


A Womand Told Me
http://www.awomantoldme.com
 
Forms also have a Pivot Table view.
You could create several forms to show the query's data in different ways.
You could then make these subforms of a main form, maybe on different pages
of a Tab Control. You could set the caption of each tab to the description of
the view.

Steve
 
Back
Top