[AccessD] TOP 10 report graph

Show totals and use GROUP BY. If other fields are different then use 
FIRST, MIN, MAX or whatever  on the other fields
On 14 Apr 2003 at 5:04, John Eget wrote:

> 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


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.