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

Chapter 12. Working with PivotTable and ... > Creating the Query for a Sample Pivo...

Creating the Query for a Sample PivotTable View

Queries designed for users who are accustomed to using Excel PivotTable should offer a high degree of flexibility for slicing and dicing the data. For example, sales and marketing managers are likely to want to explore the total value of orders received each quarter by salesperson, customer, product, country, or any combination of these selection criteria. Thus, your query must supply more than the ordinary amount of data to the PivotTable.

Tip

Don’t assign Caption property values to fields of tables you intend to use with queries for PivotTables and PivotCharts. You can’t override the Caption property with query aliases in Access 2003.

To override the Caption property value in aggregate queries, apply a function to the field that doesn’t change its values, such as Trim for text fields and Round for numeric fields. Alias the column with an AS Caption modifier. This workaround causes conventional SELECT queries to not be updatable, but most PivotTables are based on aggregate queries, which aren’t updatable under any condition.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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