Top Query

J

jd316632

Is it possible to have a query that shows everything EXCEPT the top 10?
I have one that currently shows the top 10, but now they are wanting to
see a separate report further down that shows the rest (excluding the
top 10)
 
J

Jeff Boyce

One way to do this ... a bit of a kludge ...

First, create a query that returns the top 10.

Then create a query that returns what's on the list where what's on the list
is NOT in the first query (use the query wizard and the "unmatched" query).

If you're feeling up to the SQL coding, I believe you can do this in one ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amending meeting cancels all future meetings 0
Solved Disk Full error message when exporting PDF 0
Format column widths from one table to a separate table on same page 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Auto populate value from one task to another in MS PROJECT 0
Remove title bar and phase bar by default on swimlane 0
MS Word Page Layout/Break/Margin Issues, help 0
Integrating information from Word to Excel (not mail merge) 1

Top