Top and then the rest

[jmersing]

Maybe this is a dumb question but I'm selecting the top 20 rows in a query, which works fine. What method would I use to create a sum of the remaining areas. i.e. the other 80+

Is there a "select bottom" 80? I basically want everything in the query that is not in the Top 20, just can't think of how to do it.

Thanks

 

[alansidman]

Run your top 20 query. Then bump that query against the entire table as an unmatch query. This will give you erverything other than the top 20.

Alan

 

[jmersing]

Thank you sir, jus was not sure if there were any other methods. Thanks