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

CASE EXAMPLE

Let's continue using the Northwind database to get some extra practice with crosstab queries.

Assume that the employee who is responsible for taking the order also decides on the shipper. You're Northwind's president, and you're reviewing how the company uses its three shippers. You're curious to see whether different levels of management have a preference for one shipper over another. You'll use a crosstab query to help.

The Crosstab Query

What data do you need? The Employees table has job titles, whereas the Shipper table has shipper names and the Orders table has OrderIDs. If you count the OrderIDs, you will get the breakdown of orders by job title for each shipper.

1.
Create a new query in Design view and add the Employees, ...

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