Exclude Top 10 (Create "Other" Category")

[Vetter]

I am creating a report and have a query that is sorted on dollars and pull out the top 10 dollar amounts. Now what I want to do is get all the other items and sum them up to get an "other" category. I'm able to do this currently by creating an unmatched query using the query wizard between my source table and my top 10 query.

Is there a way to accomplish this without doing these 2 separate queries?

Thanks,
Vetter

 

[dcx693]

Just in theory (because I've never tried this), perhaps you can try putting a numbered column into your query and excluding the ones numbered 1-10. Use the technique listed on this site if you don't know how to get a numbered column: Roger's Access Library. Pick your version of Access, then look for "NumberedQuery.mdb" or "NumberedQuery2k.mdb".

If your current method works, though. I would just stick with it. It works and it makes sense.