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

Filtering PivotTable Data

When you create a PivotTable from the data in your tables or queries, you often have several screens worth of data to move through. Reorganizing your data can help you interpret your data, but you can also filter your PivotTable by choosing the data you want to see. For example, if your PivotTable shows sales data for a series of products grouped by category, you can pick the categories for which you want to view data.

Select Which Field Values to Display

  1. Display the forms in your database.

  2. Double-click the PivotTable form. ...

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