Select Top 10 Only

[Chris via AccessMonster.com]

Hi, I am currently trying to select the top 10 but when the 10th, 11th , 12th etc records are the same they are listed in the top 10. This means that you end up with more than 10 records. Any idea on how I can resolve this problem?

Many Thanks

Chris

 

[Dirk Goldgar]

Hi, I am currently trying to select the top 10 but when the 10th,
11th , 12th etc records are the same they are listed in the top 10.
This means that you end up with more than 10 records. Any idea on how
I can resolve this problem?

Can you add a tie-breaker field to the query?

 

[Chris via AccessMonster.com]

Thanks for replying,

"Can you add a tie-breaker field to the query?", what is that? never heard of it sorry.

 

[Dirk Goldgar]

Thanks for replying,

"Can you add a tie-breaker field to the query?", what is that? never
heard of it sorry.

The idea is that you add one or more fields to the query's ORDER BY
clause so that when you select TOP 10, the records that were formerly
tied for 10th place are no longer tied. For example, if the table has a
primary key field, you can put that field last in the ORDER BY clause.