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
 
Top