Access Chart Issue

[Tcurtis]

Hi, I have an issue I am trying to resolve with an Access chart. I have a query that counts how many times a part appears I use as top ten list. I have a chart attached to this query but the chart does not go in descending order like my data does. The chart goes in alphabetical order instead of numerical order. How do I fix this problem? Seems it should be a simple fix but I cannot find any information on this topic.

Thanks

 

[AngelJ]

I just tested this and found that the chart would come out in the same order as my query. If you haven't done this already, explicitly define the sort order with an ORDER BY clause.

 

[Tcurtis]

Thanks but I am not sure what you are referring to. In my query I use the totals function to count the number of times a model number repeats. So in my Totals line I use count and then sort by descending. This is the only way I know how to count the number of times a model number repeats. Access is very new to me and has been kind of challenging.