Software

Analyze your Access query data in Pivot Table view

You can set up Access' Pivot Table view to show the top- and bottom-ranked items in your overall data with a simple click. Mary Ann Richardson shows you how.

Access not only lets you perform a Top/Bottom analysis of your query results in Query Table view, you can also analyze those results from the Pivot Table view of your query. For example, say you want a list of the top five most expensive shipping rates for this year's orders to date. You already have a query that lists the freight values by order ID similar to the one shown here.

Follow these steps to do the analysis:

  1. Open the query in Pivot Table view.
  2. Right-click Order ID in the table, then point to Show Top/Bottom Items.
  3. Point to Show Only The Top, then click 5.

To show the bottom 2%, follow these steps:

  1. Right-click Order ID in the table, then point to Show Top/Bottom Items.
  2. Click Show All.
  3. Right-click Order ID in the table, and then point to Show Top/Bottom Items.
  4. Point to Show Only The Bottom, and then click 2%.
Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox