How can I Order By in Access Graph Chart ?

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I am using Access 2000-03.

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
 
Your chart doesn't have a Freq column to sort by. Your columns in the chart
row source should be Personnel and values of RP.
 
Back
Top