Getting rid of ties in Top 5

T

T

Hi Everybody,

I get 9 records when I get Top 5 because there are some matches or ties ...
is it possible to get rid of these, it is driving me crazy.

Please help,
Thanks
Teresa
 
R

Rick Brandt

T said:
Hi Everybody,

I get 9 records when I get Top 5 because there are some matches or
ties ... is it possible to get rid of these, it is driving me crazy.
Click to expand...

Include more fields in the Sort of the query until the tie is broken. If
you include the Primary Key in the sort then you should never have a tie.
Of course "which 5" records you do get might be pretty arbitrary if you do
that.
 
J

Jeff Boyce

Like Rick, I'm wondering how YOU would resolve the ties? If they are truly
ties, how do you pick one over the other?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
T

T

Thank you!

Rick Brandt said:
Include more fields in the Sort of the query until the tie is broken. If
you include the Primary Key in the sort then you should never have a tie.
Of course "which 5" records you do get might be pretty arbitrary if you do
that.
Click to expand...
 

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

Remove Ties from a Top 5 query 10
Get rid of ties in Access Query 4
Getting rid of grey background from text copied from internet 1
Top Select returning Ties 3
Outlook calendar list 0
Outlook 365 extremely stubborn 0
Black Lines appearing over table borders 0
Name of file opened, being viewed 2

Top