Simple. Everyday. Automation.

Employee Training Database

Course Training

Using Crosstab Query to Generate Table

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


  • Normalize tables
  • Create new filters for data 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 subreport 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 subreports.

[ws_table id=”1″]