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

Crosstab Queries

A Crosstab query summarizes query results by displaying one field in a table down the left side of the datasheet and additional facts across the top of the datasheet. A Crosstab query can, for example, summarize the number of orders placed each month by a salesperson. The name of each salesperson can be placed in the query output's leftmost column, and each month can be displayed across the top. The number of orders placed would appear in the appropriate cell of the query output. (See Figure 12.20.)

Figure 12.20. An example of a Crosstab query that shows the number of orders placed by each employee by month.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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