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

Chapter 9. Queries, Part II > Crosstab Queries

Crosstab Queries

Take almost any subject: sports, finance, politics. The professionals who make their money analyzing what goes on are always talking about “breaking down the numbers.” Traffic accidents in Pleasantville totaled 72 last month; how many occurred east of Main Street, and how many west of Main Street? The freshman class at Ivy University has 1,784 students; how many come from each country? Total employees at Acme Widget number 3,587; how many are in each of the Production, Marketing, and Financial divisions?

Often you'll want to find and compare breakdowns among different items in a single group. For example, you might want to see the country-by-country totals for the freshman class at each of the Ivy League schools.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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