Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques

715

FIGURE 20.7

The January sales data grouped by each week during the month

FIGURE 20.8

OrderDate is a date/time field, so the grouping options are relevant for date and time data.

The label at the top of the group identifying the week (the first one reads Week beginning

1/1/12:) is the product of the following expression in an unbound text box in the OrderDate

group header:

=“Week beginning “ & [OrderDate] & “:”

See the Design view of rptSalesJanuaryByWeek in Figure 20.9. Notice the unbound text box

in the OrderDate group header. This text box contains the value of the order date that Access

used to group the data in the OrderDate grouping.