How to Create Crosstab Queries in Access 2010


show more Creating crosstab queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating crosstab queries

Instead of viewing all your data based on one criteria, you can analyze it on two or more variables using Crosstab Queries. Maybe you're curious about how many bottles of each type of oil is sold everyday. To do that, you'll use a Crosstab Query to compare order date to products, and sum the quantity. Click on Create to start a new query. Choose Query Wizard. Choose the second option, Crosstab Query Wizard, and click OK. First, pick the table you'll be analyzing.

We'll choose Orders. It's important to note that you can also build Crosstab Queries based on the fields from multiple tables. But to do that, you would need to create a Select Query to join the fields from all your tables into one place. Then you can build the Crosstab from that one query. Click Next, and choose what field you want for the rows. For us, that will be OrderDate. Click on it, and click the arrow to move it over. Click Next. Now, we'll choose our column headers.

In this case, we'll analyze our ...

Creating crosstab queries
Video duration: 2m 6s 3h 30m Beginner

Viewers:

Creating crosstab queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...