Getting rid of ties in Top 5

[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

 

[Rick Brandt]

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.

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.

 

[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

 

[Guest]

Thank you!

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.