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.

On Mar 24, 4:04 pm, Luke <L...@discussions.microsoft.com> wrote:
> 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 [TABLE]
ORDER BY [COLUMN] DESC;

On Sat, 24 Mar 2007 13:04:15 -0700, Luke <(E-Mail Removed)>
wrote:

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