O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 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, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required