Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cross-tab data in a report (2000)

    I need to display monthly data (column headers) in a report - and the months in the report change monthly. Can someone direct me to posts on using VBA to modify the label and text box control sources to accomplish this?

    Thanks!

    Larry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cross-tab data in a report (2000)

    There have been several discussions about dynamic column headings for crosstab reports. If you do a search with keywords dynamic crosstab, you will find them. For example, <post#=35485>post 35485</post#> and <post#=134439>post 134439</post#> have demos attached.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •