Travis- SELECT Top 10 MyTable.* FROM MyTable ORDER BY SalesAmt DESC;
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/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Travis R. Simons > Sent: Thursday, June 09, 2005 6:53 PM > To: [email protected] > Subject: [ms_access] Top 10 in a query > > > I would like to know how to pull a query for the top ten dollar > amounts, of 200 entries, in descending orders. > > -- > Travis Simons > 512.388.5808 > > > > 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/
