Microsoft Office Tutorials and References
In Depth Information
Using the Crosstab Query Wizard
you want to
use in the
4. In the new window that appears, shown in Figure 4-3, select the
field(s) whose values you want to use as row headings and then
You can select up to three fields to fine-tune the breakdown of your
data. As you select fields, the sample at the bottom changes to reflect
how your finished query will look.
Generally, the fields you select as row and column headings contain
repeated data that is grouped in the Crosstab query. The ProductID
field, for example, comes from the Order Details table and identifies
products in each order. The Crosstab query can show you how many
times a product is ordered or how many units of each product are sold.