ACC2000 Article in Knowledgebase not accurate

  • Thread starter Thread starter Keena
  • Start date Start date
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.
 
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
 
Back
Top