Print Page | Close Window

Cross Tab

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Hookom, Duane
Forum Description: Duane Hookom's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=11
Printed Date: 13 Dec 2017 at 2:14am


Topic: Cross Tab
Posted By: Duane Hookom
Subject: Cross Tab
Date Posted: 23 Jun 2008 at 10:38pm
This Access 97 mdb demonstrates how to create a report from a crosstab query where the column headings will not be known until run-time. The report will accomodate any number of columns with extra columns "wrapping" under the first set of columns.

This type of report could be used to display salesperson orders and dates as row headings and customers as column headings. The method I developed will dynamically create columns to match each different salesperson. If a salesperson has 2 or 20, the report will accommodate them all. This method runs fairly quickly and requires only about 20 lines of code.

Download Access 97: http://www.rogersaccesslibrary.com/forum/uploads/4/CrossTab.zip - uploads/4/CrossTab.zip


-------------
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI



Print Page | Close Window