Select TOP

[Rachel]

Hi All,
Does anyone know the best way to get a query to select the
Top 10 people who have the lowest figures in a particular
field?
Many thanks for any assistance.
Rachel

 

[May]

SELECT TOP 1 table2.name, table2.number
FROM table2
ORDER BY table2.number;

when you sort the query by number in ascending order, it
will show the lowest number for you
if you sort by number in descending order, then it will
show the hightest
you may right click anywhere above the panel and click on
properties, then you can enter Top ? there

May
MCP in Access and SQL Server