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

Chapter 13. Locating and Managing Data w... > Summarizing Values with a Crosstab Q...

Summarizing Values with a Crosstab Query

A crosstab query allows you to summarize the contents of fields that contain numeric values, such as Date fields or Number fields. In this type of query, the results of the summary calculations are shown at the intersection of rows and columns. For example, you can use a crosstab query to calculate the total number of toy products on sale, broken down by toy type. Crosstab queries can also involve other functions such as the average, sum, maximum, minimum, and count. You cannot update crosstab queries. The value in a crosstab query cannot be changed in order to change the source data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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