Find Top 10 items from a query

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

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.

"Jasper Recto" wrote:

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

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


"Jasper Recto" wrote in message
...
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

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" wrote:

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

THANKS!!
"Steve" wrote in message
m...
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


"Jasper Recto" wrote in message
...
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