Lee,

OK - I shouldn't be working on Halloween, the goblins
obviously got my brain. What is it that you expect in
the result? As described, you're restricting your original
input to a single order. If I understand, if the data is
this

order item description
1 1 witch
1 2 goblin
1 3 goblin
1 4 ghoul

you'd like to see a report like this:

count price order desc
1 ??? 1 witch
2 ??? 1 goblin
1 ??? 1 ghoul

in that order.

I'd try getting the summaries in subqueries and use a
main query that selects distinct description.


Regards,


Ann