ACC2000 Article in Knowledgebase not accurate

K

Keena

When trying out MS's answer to sort the columns on a chart
according to Article 208651, I get the following error
message "Cannot have aggregate function in ORDER BY clause
SUM([FreqMyds])". Any other way to do this? I want to
sort in descending order.
 
L

Larry Linson

It is true that SUM is an aggregate function (that is, it won't be different
for each record) and that aggregate functions aren't suitable for ORDER BY.

It's possible that there is another way to do it, if only we knew what data
you have, and how you want it ordered, and didn't have to go to the
Knowledge Base to look up an article, and ...

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph question in Access2007 5
Sorting Charts By Descending Order 0
Order by Asc or Desc a"Total Sum" in a Crosstabquery 2
having clause not accepted by MS Access 0
Report sorting function 2
Select "All" in Combo Box 6
can't use an aggregate function in an expression? 5
How do I sort subtotals for groups in Excel ? 5

Top