CrossTab Query with Moving Dates

[wongray]

Hello,



I like to create a crosstab query that will allow me to show the future month in the report.

example: In Apr 2012 report. it will show below.

Target Product - May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr
Product A - 10,20,0,10,10,20,11,10,10,10,11,20

In May 2012
Target Product - Jun, Jul, Aug, Sep, Oct, Nov, Dec, Jan, Feb, Mar, Apr, May
Product A - 20,0,10,10,20,11,10,10,10,11,20,10

Anyway to do a moving months in a Crosstab Query?

Many Thanks
Ray

[June7]

That is the issue with crosstabs using dates as column headers, they are so dynamic. Stablizing them is not easy. I would probably do a VBA solution. This thread http://forums.aspfree.com/microsoft-...ry-322123.html has example of VBA code that 'transposes' data to horizontal (left to right) output.