Travis, This should solve...
SELECT top 3 tblpipeline.Customer, tblpipeline.Revenue, tblpipeline.Probability, tblpipeline.Notes FROM tblpipeline WHERE (((tblpipeline.Printer_Consultant) Like "*simons*") AND ((tblpipeline.Quarter) Like "*q3*") AND ((tblpipeline.Status) Like "*outstanding*")) order by tblpipeline.Revenue desc ; This will sort the data in Descending order and top 3 will fetch you the top 3 data by revenue. --- "Travis R. Simons" <[EMAIL PROTECTED]> wrote: > John, > Can you help me with your information for the > following real qry? I > want to pull the top three by revenue. > > > SELECT tblpipeline.Customer, tblpipeline.Revenue, > tblpipeline.Probability, tblpipeline.Notes > > FROM tblpipeline > > WHERE (((tblpipeline.Printer_Consultant) Like > "*simons*") AND > ((tblpipeline.Quarter) Like "*q3*") AND > ((tblpipeline.Status) Like > "*outstanding*")); > > > > On 6/9/05, John Viescas <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > > > > > > > > > > > > -- > Travis Simons > 512.388.5808 > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h732ara/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123535414/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> 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/
