O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required