Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Hookom, Duane
  New Posts New Posts RSS Feed - Cross Tab
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Cross Tab

 Post Reply Post Reply
Author
Message Reverse Sort Order
Duane Hookom View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Location: Eau Claire, WI
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duane Hookom Quote  Post ReplyReply Direct Link To This Post Topic: Cross Tab
    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
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.