Microsoft® Office Access 2003 Inside Out

Creating the Basic Facility Occupancy by Date Report

For many reports, building the source query is the most difficult step. Once you have the data you need and understand the grouping options and properties you can set, building the report is easy. I actually like to use the Report Wizard to get a jump-start on laying out my reports. The wizard works especially well when the record source contains 10 or fewer fields.

To start designing the Facility Occupancy by Date report, select the query in the Database window, choose Report from the New Object toolbar button, click Report Wizard in the New Report dialog box, and click OK. Build the basic report by taking the following steps:

1. In the first window of the wizard, choose the FacilityName, DateValue, ...