Top 10 Qry

[tuktuk]

i have a simpy qry that sums totals [Volume] for [PayCountry]. there are approx 200 pay countries listed.

I know if i Desc of [Volume] and select 10 in the TopValues that will give me the top 10 listed.

What is the best way to Sum all of the other countries in to one Paycountry row call "All Other" and then have all of the 10 Paycounties and hte "all other" in one qry.

Can this be done in one qry? Or do i have to append 2 qry results to a table?

Thanks

 

[Trevor G]

Look to run 2 queries and append results into a temp table.