Sorting Categories in a pivot chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Is Month a numeric field? If not, it should be since it would make life much
simpler for you.
 
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


Ken D. said:
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?
Click to expand...
Click to expand...
 
Back
Top