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.
This is the ...
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
