[AccessD] TOP 10 report graph

With only one field this won't work, but if you can put a second field in 
your query and sort on two fields instead of just one - and use something 
unique like a record key, you will only get 10 results.

Gary Kjos
garykjos at hotmail.com





>From: "John Eget" <joeget at vgernet.net>
>Reply-To: accessd at databaseadvisors.com
>To: <AccessD at databaseadvisors.com>
>Subject: [AccessD] TOP 10 report graph
>Date: Mon, 14 Apr 2003 05:04:34 -0400
>
>Anyone
>I have a query that generated a table for reference on a report to display 
>the top ten events recorded. i.e. SELECT TOP 10 [table] [item]. The only 
>problem is when the 10th item displayed is the same as the 11th or 12th or 
>13th etc. Then all of the items that agree with the 10th item are also 
>displayed. Is there a way to ONLY display the TOP 10 and not anything else?
>Thanks for the help in advance
>John
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail