Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

716

FIGURE 20.9

The Design view of rptSalesJanuaryByWeek. Notice the expression in the OrderDate group header.

Hiding repeating information

An easy improvement to tabular reports is to reduce the amount of repeated information on the

report. Figure 20.10 shows a typical tabular report (rptTabularBad) produced by Access, based

on a simple query of the Northwind Traders data.

FIGURE 20.10

Simple tabular reports can be confusing and boring.

The report in Figure 20.10 was produced with the Access Report Wizard, selecting the tabular

report format and all defaults. The query underlying this report selects data from the Customers,

Orders, and Employees tables in Northwind.accdb and is shown in Figure 20.11. Notice that

the data returned by this query is restricted to the month of January 2012. Also, the first and last

names of employees are concatenated as the Name field.