You must change the Name property of the control to something like txtDiscount so that
Access can tell the difference between the control??™s name and the underlying field.
Use Snaking Columns in a Report
When the data displayed on a report doesn??™t require the full width of the page, you may be able to
conserve the number of pages by printing the data as snaking columns, as in a dictionary or phone
book. Less space is wasted and fewer pages need to be printed, speeding the overall response of the
report. More information is available at a glance and many people find snaking columns more aesthetically
pleasing than simple blocks of data.
For the examples in this section, we need a query that returns more data than we??™ve been using up
to this point. Figure 20-29 shows the query we??™ll be using to prepare the sample reports in this
section.
677
Advanced Access Report Techniques 20
FIGURE 20-29
This query returns more detailed information than we??™ve been using.
This query returns the following information: company name, order date, order ID, product name,
unit price, and quantity for the period from January 1, 2008, to March 31, 2008.
Pages:
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332