I have a query with (at present) 223 records, sorted from highest
percentage to lowest percentage.
I would like to create two more queries. One would contain the top 27%
from the first query and the other would contain the bottom 27%.

Access SQL would seem to make this easy. I just start my "top" and
"bottom" queries with the clause "SELECT TOP 27 PERCENT".

But that should give me 60 records in both the Top and Bottom queries,
right? Instead, I get 74 records in the top 27% query and 69 in the
bottom 27% query.

Anybody know why this is? Anything I can do differently to get the
results I'm looking for?

Thanks!

septimus wrote:
There's probably some ties. You need to break the ties by adding as many
fields are needed to the ORDER BY clause.