• 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 dollars sold by a salesperson to each company. You can place the name of each company in the query output's left-most column, and you can display each salesperson across the top. The dollars sold appear in the appropriate cell of the query output (see Figure 11.20).

Figure 11.20. An example of a Crosstab query that shows the dollars sold to each company by salesperson.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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