We help IT Professionals succeed at work.
Get Started

Building a Report off of a Crosstab Query

IEHP1
IEHP1 asked
on
641 Views
Last Modified: 2012-10-10
Hi, I have searched long and hard to see if there is any way possible to create a report that uses a Crosstab query as its record source without having to manually insert or edit the Column Headings property (ya know, to fill it in to say what it needs to say for all of the labels).

I just have a report I would like to create that could dynamically report on the month's being reported. For example, if the query parameter for From and Through Dates is for 1 year's worth of time, the labels should say Jan '11, Feb '11, etc., etc..... You get it?

I am not too good at VBA but I am open to using examples.

Let me know alright,
Thank you
Comment
Watch Question
Retired IT Professional
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 46 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE