651
Advanced Access Report Techniques 20
FIGURE 20-6
A rearrangement of the data shown in Figure 20-4, earlier in this chapter
Let??™s assume we want to refine the rptSalesJan08Alpha1 report by labeling the groups with
the letters of the alphabet. That is, all customers beginning with B (B??™s Beverages, Berglunds snabbk?¶p,
Blondel p??re et fils, and so on) are in one group, all the C customers (Com?©rcio Mineiro,
Consolidated Holdings, and so on) in another group, and so on. Within each group the company
names are sorted in alphabetical order. The sales to each customer are further sorted by order ID.
To emphasize the alphabetical grouping, a text box containing the first character for each group has
been added to the report (see rptSalesJan08Alpha2 in Figure 20-7). Although our data set in this
example is rather small, in large reports such headings can be useful.
FIGURE 20-7
An alphabetic heading for each customer group makes the rptSalesJan08Alpha2 report easier to read.
652
More Advanced Access Techniques Part III
Adding the text box containing the alphabetic character is easy:
1.
Pages:
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293