3. Using a crosstab query to reflect a set of data comparisons Create a new query, select the Crosstab Query Wizard, and then select Fleet Transport Query, which appears in the above dialog box and selects the driver field as the row heading from the available fields. Click Next. Then select "Cargo category" from the field as the column heading. Click Next. Select the "Net Weight" field, the function selects "sum", finally a name for the crosstab query, and the wizard ends. The diagram above is the Design view of the query you just generated. The table below is the result of the crosstab query, which clearly contrasts the number of goods each driver transports. 1715.40 922.30 1601.90
Fleet Transport query--cross-table
driver |
scrap stone |
fine powder |
|
|
|
Li Dafang |
170.00 | TD style= "BORDER:0;PADDING:0;" >
13.50 |
310.00 |
2208.90 |
Wang |
18.50 | TD style= "BORDER:0;PADDING:0;" >
15.90 |
21.30 |
978.00 |
Zhang cute |
310.00 | TD style= "BORDER:0;PADDING:0;" >
94.20 |
340.00 |
2346.10 |
Zhao Beautiful |
790.00 |
1537.40 |
21.60 |
420.00 |
2769.00 |
|