M mR_BroWnliE via AccessMonster.com Sep 28, 2005 #1 Hi guys i really need a Query to show the top ten entrys in a table :}
B Brendan Reynolds Sep 28, 2005 #2 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
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
G Guest Sep 28, 2005 #3 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
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
