I have tblSoldHistory data base with fields:
PartNo, M01, M02, M03, ..., M11, M12
L1, 100, 300, 50, ...., 200, 250
l2, 150, 250, 100, ..., 250, 350
etc.
M12 represent CurrentMonth -1 (May05 )
M01 represents CurrentMonth-12 ((June04 )

In my form, based on link PartNo->PartNo, I added chart QuantitySold for a last 5 month.

SELECT Null AS Expr1, Sum([M08]) AS M08 , Sum([M09]) AS M09 , Sum([M10]) AS M10 , Sum([M11]) AS M11 , Sum([M12]) AS M12 , Sum([Last_5M]) AS Last_5Month FROM tblSoldHistory ;

Everything is OK, except that on my chart, X-axis labels are: M12, M11, M10, M09, M08 .

My question is:
How can I replace M12 with May05 , M11 with April05 , M10 with March05 etc?
Of course, each month should display updated month names.

In Report I replaced label with text field:
=DateAdd("m",-1,Date())
=DateAdd("m",-2,Date())
=DateAdd("m",-3,Date())
=DateAdd("m",-4,Date())
=DateAdd("m",-5,Date())