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,