How to order chart in descending order of Freq?
 

I am using Access 2000-03. The graph is a subset to excel, but very close.

I have a Access Graph Chart with the Row Source set to:

"TRANSFORM Sum([Freq]) AS [SumOfFreq] SELECT [Personnel] FROM
[Rept#704_Joint_Personnel] GROUP BY [Personnel] PIVOT [RP];"

Currently, my graph order the personnel in Ascending order of Personnel. I
want to now order it by Descending Order of Freq.

In the query [Rept#704_Joint_Personnel], I have the following fields:
a) Freq
b) Personnel

Can someone please help me here!

Thank You,

Gary

How to order chart in descending order of Freq?
 

I don't know how you'd have to modify your SQL statement, and I don't
know for sure how Access does its charting. But I presume if the data
comes in sorted, the chart will present it sorted. If it comes in
unsorted, that's what the chart will show.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Gary wrote:
I am using Access 2000-03. The graph is a subset to excel, but very close.

I have a Access Graph Chart with the Row Source set to:

"TRANSFORM Sum([Freq]) AS [SumOfFreq] SELECT [Personnel] FROM
[Rept#704_Joint_Personnel] GROUP BY [Personnel] PIVOT [RP];"

Currently, my graph order the personnel in Ascending order of Personnel. I
want to now order it by Descending Order of Freq.

In the query [Rept#704_Joint_Personnel], I have the following fields:
a) Freq
b) Personnel

Can someone please help me here!

Thank You,

Gary