access query help

L

Luke

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.
 
K

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.
Click to expand...


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

ORDER BY [COLUMN] DESC;
 
J

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.
Click to expand...

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]
 
Top