descending order in a graph

[5280]

I have a graph included in a report, I am running this off of a query. I need to have the results in the graph be ordered the numercial values that the graph is graphing, in descending order. How do I do this? Please help.

Thank you.
AT

 

[dhookom]

Your graph is based on the Row Source property of the control. If you change the Row Source sorting, you change the graph.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[5280]

This is what is written in the row source.....SELECT [Cat/Class] AS Expr1, Sum([Cat/ClassCount]) AS [SumOfCat/ClassCount] FROM qryCategoryRankingCount GROUP BY [Cat/Class];

It is alphabetizeing/ordering them by the label associated with the value, I actually want the value in decending order.

Please let me know if you have any ideas.

 

[dhookom]

Change this to order by Sum([Cat/ClassCount]).

Duane
MS Access MVP
Find out how to get great answers faq219-2884.