Crosstab results Displaying order

[Chimp8471]

i have a crosstab query that runs and all works fine except one thing,

the months are displayed in the wrong order...

they appear like:

April, Feb, Jan,Jul, jun, mar, may

these are obviously being sorted in alphbetical order, can this be changed to sort by months as they should be

cheers

Andy

dunno if it help but here is my current code:

TRANSFORM Avg(FactoryModel_OEE.AvgOfOEE) AS OEE
SELECT [FactoryModel_OEE Year2003].OEE AS 2003, FactoryModel_OEEYear2004.OEE AS 2004, FactoryModel_OEEYear2004.TargetOEE AS Target
FROM [FactoryModel_OEE Year2003], FactoryModel_OEEYear2004, FactoryModel_OEE
GROUP BY [FactoryModel_OEE Year2003].OEE, FactoryModel_OEEYear2004.OEE, FactoryModel_OEEYear2004.TargetOEE
PIVOT Format([Month],"mmm/yy");

 

[ByteMyzer]

Try:

TRANSFORM Avg(FactoryModel_OEE.AvgOfOEE) AS OEE
SELECT [FactoryModel_OEE Year2003].OEE AS 2003, FactoryModel_OEEYear2004.OEE AS 2004, FactoryModel_OEEYear2004.TargetOEE AS Target
FROM [FactoryModel_OEE Year2003], FactoryModel_OEEYear2004, FactoryModel_OEE
GROUP BY [FactoryModel_OEE Year2003].OEE, FactoryModel_OEEYear2004.OEE, FactoryModel_OEEYear2004.TargetOEE
PIVOT Format([Month],"mmm/yy") IN ('Jan/04','Feb/04','Mar/04','Apr/04','May/04','Jun/04','Jul/04','Aug/04','Sep/04','Oct/04','Nov/04','Dec/04');