SELECT Top 10 ID, Total FROM MyTable ORDER BY Total Desc; If you want the top 10 values per ID, then do:
SELECT ID, Total FROM MyTable WHERE Total IN (SELECT Top 10 Total FROM MyTable As T2 WHERE T2.ID = MyTable.ID) John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Abu Bakar Chowdhury Sent: Monday, April 17, 2006 12:40 AM To: ms_access@yahoogroups.com Subject: [ms_access] Top 10 query Hi I have a table where I have ID and total fields. I want to get top 10 values from total field. How would I do that? Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
