Top 10

[jonnymenthol]

Hello,

I'm trying to run a query to give the top 10 records. However, if there is a joint 10th, for example records 9, 10 and 11 all have a count of 15, then I only want the 10th.

Can this be done ?

I have tried using unique values and unique records within the properties of the query, but it doesn't appear to work.

Thanks.

J.

 

[WayneRyan]

jonny,

Computers hate to make decisions. When there is a tie in the criteria, how
would you expect the SQL engine to act? Return only the Top 9 or
the Top 12?

You could make a recordset and pick exactly the first 10, but then you
will have to decide which one(s) get omitted.

Wayne