O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John 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

Building a Query for a Complex Report

To explore some of the advanced features you can include in a client report, let’s build a report in the Housing database that displays room occupancy information by facility, date, room, and employee. As noted in Chapter 17, reports tend to bring together information from many tables, so you are likely to begin constructing a report by designing a query to retrieve the data you need for the report. For this example, you need information from the tblFacilities, tblReservations, and tblEmployees tables in the HousingDataCopy2.accdb database. Open a new Query window in Design view by clicking the Query Design button in the Queries group on the Create tab, and add these tables to the query window.

The tblReservations ...

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