O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Pivoting a PivotTable

Perhaps the biggest benefit of presenting your data using PivotTables is that you can change the data’s organization on the fly, creating literally dozens of different forms from a single data set! All you have to do is drag the header of the field you want to move to its new position—when you release the mouse button Access examines the PivotTable’s new structure and rearranges the data to match it. If previously you had listed sales by Country and then by product Category, you could drag the Category field header to the left of the Country field header to reverse the grouping.

Reorganize PivotTable Data

  1. Display the forms in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required