After you create a query, display the datasheet to make sure that the data you expect to see is displayed,
and that the type of data lends itself to PivotTable analysis. There should be many different
groupings of data because a PivotTable is intended to manipulate, or pivot about, different data
categories.
A category is the equivalent of a type table in a relational database terminology.
As shown in Figure 24-23, this data is perfect for PivotTable analysis. There are many customers,
each having several purchases, on several dates, plus a total payment for each sale.
After the data is reviewed, you can create a PivotTable. You start by selecting the View menu with
the query in Figure 24-23 still open, and then the PivotTable View on the menu. After you begin
the PivotTable Wizard process, you see an introductory screen describing exactly what to put
where, as shown in Figure 24-24.
NOTE
794
More Advanced Access Techniques Part III
FIGURE 24-23
The datasheet version of the query shown in Figure 24-22
FIGURE 24-24
The PivotTable layout design wizard
795
Using ActiveX Controls 24
Figure 24-24 shows a number of sections plus a field list selection box.
Pages:
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516