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: 28 Mar 2024 at 9:58am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


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

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net