Microsoft® Access® 2010 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. We actually like to use the Report Wizard to get a jump start on laying out our client 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 Navigation pane, and click the Report Wizard button in the Reports group on the Create tab. Build the basic report by taking the following steps:

1. On the first page of the wizard, choose the FacilityName, DateValue, RoomNumber, and EmpName fields, ...