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

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