Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques

717

FIGURE 20.11

The simple query underlying rptTabularBad

The query in Figure 20.11 (qrySalesJanuary) is used as the basis of several examples in this

chapter.

You can significantly improve the report in Figure 20.10 simply by hiding repeated information in

the Detail section. As soon as Andrew Fuller’s name is given, there’s no need to repeat it for every

sale that Andrew made in January 2012. The way the data is arranged on rptTabularBad, you

have to search for where one employee’s sales data ends and another employee’s data begins.

Making the change to hide the repeated values is very easy:

1. Open the report in Design view.


2. In the Detail section, select the EmployeeName field containing the employee’s first and
   last names.


3. Open the property sheet for the Name field (see Figure 20.12).

FIGURE 20.12

The default property values sometimes lead to unsatisfactory results.