Select Top 10 - tie

[rishhh]

Hello,

I am running a select Top 10 query. When there is a tie this query gives me numbers more than 10. I read some other posts, which talked about 'With Tie' clause included in the Top 10 predicate in Access.

Is there any way to work around such ties and display only 10 records (whether tying or not)?

Thanks

[Rabbit]

Will including they primary key field cause problems?

[rishhh]

Will including they primary key field cause problems?

I do not have primary keys defined. I cant define them as this is a temporary reporting process and the data i get does not allow me to define primary keys - not even composite primary keys.
Even if there was a primary key, in this particular example, it may not be useful. Do you think there is any other way to tackle the Top 10 ties?
Thanks a lot for responding. I appreciate it.

[Rabbit]

I do not have primary keys defined. I cant define them as this is a temporary reporting process and the data i get does not allow me to define primary keys - not even composite primary keys.
Even if there was a primary key, in this particular example, it may not be useful. Do you think there is any other way to tackle the Top 10 ties?
Thanks a lot for responding. I appreciate it.

I was just thinking that if you had a primary key, you could just throw that into the the SELECT and it would mean you can't have a tie. What about throwing an autonumber field into the mix? As long as you're not using aggregate functions then it should be fine.

I don't think there's a way to get around the tie with a SQL predicate.

[rishhh]

I was just thinking that if you had a primary key, you could just throw that into the the SELECT and it would mean you can't have a tie. What about throwing an autonumber field into the mix? As long as you're not using aggregate functions then it should be fine.

I don't think there's a way to get around the tie with a SQL predicate.

Thanks a lot for your help. I added more columns to the ORDER BY clause to further minimize the possibility of a tie. I appreciate your help.

[Rabbit]

Thanks a lot for your help. I added more columns to the ORDER BY clause to further minimize the possibility of a tie. I appreciate your help.

Not a problem, good luck.