Microsoft® Office Access 2003 Inside Out

Chapter 16. Advanced Report Design

Building a Query for a Complex Report

Creating the Basic Facility Occupancy by Date Report

Defining the Sorting and Grouping 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 a 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 the Facility Occupancy by Date report ...