top ten

[mR_BroWnliE via AccessMonster.com]

Hi guys i really need a Query to show the top ten entrys in a table :}

 

[Brendan Reynolds]

Here's an example using the Orders table in the Northwind sample data base
....

SELECT TOP 10 Orders.*, Orders.OrderID
FROM Orders
ORDER BY Orders.OrderDate DESC , Orders.OrderID DESC;

For details, see the following on-line help topics ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322051033

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880331033

 

[Guest]

It's depend which field indicate when the record been entered to the table,
Auto keys or Date, sort this field Desc and ask for the top 10 records

Select Top 10 TableName.* From TableName Order by KeyField Desc