Find Top 10 items from a query

[Jasper Recto]

I have a query that sorts items from table. I would like to only determine
and view the top items on that list.

Is that possible?

Thanks,
Jasper

 

[Dennis]

SELECT TOP 10 ..... etc.

or put 10 in the drop down box that says All on the query menu toolbar if in
the query design view.

 

[Dale Fye]

Keep in mind that the Top predicate will return more values than you want if
the field in your Order By clause has duplicates at the cutoff point.

SELECT Top 2 * from your_Table ORDER BY [DOB] DESC

will return 3 people if the 2nd and 3rd person have have same DOB. To
preclude this, you can add another field to the Order By clause that is
unique.

--
HTH
Dale

Don't forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Jasper Recto]

THANKS!!

Open your query in design view and click in a blank area of the query
window (Where your table is at). Click on Properties. In the Properties
dialog, set the Top property to an appropriate value to get the top items
in your query.

Steve