Select Query - Top Values Plus "All Else"

[Madmartigan]

I have two fields in a table that I'm querying. Customer and dollar amt. I am trying to run a top 10 query (sum of dollar amt sorted descending) by customer which I can do fine, but I'd like an 11th row that basically sums all remaining customers not present in the top 10 (so that the sum of my 11 records equals the sum of all records on my table). I'd like for the 11th row Customer value to display "All Else" if possible. In another job I had a co-worker who accomplished this but I have no clue how he did it.



Any help is appreciated.

[June7]

Possibly your former co-worker did one query for the top10, another query for everything not in the top 10, then combined the two with UNION query.