Microsoft Office® Access 2007 Inside Out

Chapter 16. Advanced Report Design

Building a Query for a Complex Report

Creating the Basic Facility Occupancy By Date Report

Defining the Grouping and Sorting Criteria

Setting Section and Report Properties

Using Calculated Values

Creating and Embedding a Subreport

Adding a PivotChart to a Report

In the previous chapter, you learned how to create a relatively simple report with a single subtotal level. You also saw how the Report Wizard can help you construct a new report. This chapter shows you how to

• Design a report with multiple subtotal groups

• Add complex calculations to a report

• Embed a report within another report

• Create a report with an embedded PivotChart form

To learn how to work with these features, you’ll create a Facility Occupancy By ...