• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. What Every Developer Needs to... > Creating a Pivot Table or Pivot Char...

Creating a Pivot Table or Pivot Chart from a Query

Pivot tables and pivot charts provide great ways for you to summarize detailed data stored in your Jet and SQL Server databases. Pivot tables present your data in a spreadsheet-like format, whereas pivot charts automatically render pivot table views as line, bar, or area charts. New in Access 2002 were two new views for queries: PivotTable and PivotChart. These views are available for both your conventional Jet applications (MDB) and your Access Projects (ADP).

Creating the Query to Display in PivotTable or PivotChart View

The first thing you must do is build a query that is appropriate to display in PivotTable or PivotChart view. Queries that lend themselves to be displayed in pivot table or pivot chart view provide many ways for the user to manipulate their data. An example of such a query is one that contains information about country, city, salesperson, sales, and date of sale. You could determine sales by city and salesperson for each month, or you could determine sales in each country for each salesperson during the year 2002. As you can see, the idea of pivot tables is to let you slice and dice the data in any way you need to at a given moment in time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint