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