Bar Chart - Sorting Columns Descending

P

Peter Leman

My question: I have a query that consists of two columns: (1) a Name and (2)
a percentage value for that name. The query is sorted descending so that the
name with the highest percentage is listed first.

My goal is to create a Bar Chart that lists (from left to right), the names
with the highest percentage first, followed by the second highest percentage,
etc.

When I create the bar chart, the columns are sorted alphabetically, by name,
rather than by value. Any suggestions on how to force Access to display the
columns in the proper order?

Does this command mean anything?

SELECT [Name],Sum([Percent]) AS [SumOfPercent] FROM [Q2-Part4] Group BY
[Name];

Thanks

Peter Leman
 
Top