Line Chart

[Guest]

Hello,

I have a line chart report that has the x axis categorized into month and
year. It goes from Jan 2000 to Dec 2001. How can I make it dispay only the
month regardless of year. e.g. Jan would be for 2000 and 2001. Here is the
record source:

TRANSFORM Sum([ProductQty]) AS [SumOfProductQty] SELECT
(Format([SellDate],"MMM 'YY")) FROM [product] GROUP BY (Year([SellDate])*12 +
Month([SellDate])-1),(Format([SellDate],"MMM 'YY")) PIVOT (Year([SellDate]));

Thanks much
-Joe

 

[Guest]

In the format function, get rid of YY