Sorting Categories in a pivot chart

[Guest]

I have a pivot chart based on the following query.

TRANSFORM Sum([Fund Volume]) AS [SumOfFund Volume] SELECT [Month] FROM
[Business Snapshot - Fundings] GROUP BY [Month] PIVOT [Year];

The months are sorting in alpha order rather than calendar order. I tried
an ORDER BY command but it keeps returning an error message. Any ideas?

 

[Duane Hookom]

Is Month a numeric field? If not, it should be since it would make life much
simpler for you.

 

[Guest]

Duane,

It is alpha but I did create a field called [Month#] and I am able to sort

Is Month a numeric field? If not, it should be since it would make life much
simpler for you.

--
Duane Hookom
MS Access MVP

I have a pivot chart based on the following query.

TRANSFORM Sum([Fund Volume]) AS [SumOfFund Volume] SELECT [Month] FROM
[Business Snapshot - Fundings] GROUP BY [Month] PIVOT [Year];

The months are sorting in alpha order rather than calendar order. I tried
an ORDER BY command but it keeps returning an error message. Any ideas?