Getting rid of ties in Top 5

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
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...
 
Back
Top