Course Training
Using Crosstab Query to Generate Table

Task: Merge two Microsoft Access databases into one database and create various reports that could be output to PDF.


  • Normalize tables
  • Create new filters for database retrieval
  • Create tabular reports

The client needed several reports with multiple tables (sub-reports) in each. The toughest table to create required a crosstab query to be the source query for a secondary filter that converted integers to X‘s in a sub-report table. A Switch function was used with each column to accomplish this. (Click the image above for the secondary filter. Click the image below for a collage of the crosstab.)

Course Training
Building the Crosstab Query

Besides queries and filters, special grouping and sorting techniques were required to enable empty tables to appear in the reports. Normally, Access refuses to display empty sub-reports.

Click on a project link for more details about that specific project.