Cross Tab |
Post Reply |
Author | |
Duane Hookom
Microsoft MVP Joined: 20 Feb 2008 Location: Eau Claire, WI Status: Offline Points: 12 |
Post Options
Thanks(0)
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: uploads/4/CrossTab.zip |
|
--
Duane Hookom Microsoft Access MVP Eau Claire, WI |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |