access query help

[Guest]

im trying to set the criteria in a query to only show the top ten numbers of
a column. what's the command i need to use? im using access 2000.

 

[Kerry]

im trying to set the criteria in a query to only show the top ten numbers of
a column. what's the command i need to use? im using access 2000.

The SQL would be something like:
SELECT TOP 10 [COLUMN]*
FROM

ORDER BY [COLUMN] DESC;

 

[John W. Vinson]

im trying to set the criteria in a query to only show the top ten numbers of
a column. what's the command i need to use? im using access 2000.

Kerry's SQL will work fine; another way to do the same thing is to right
mouseclick in the query design grid (on the grey background of the table
window), view the query's Properties, and set the Top Values property to 10.
Make sure you're sorting by the desired column.

John W. Vinson [MVP]