O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

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

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