[AccessD] TOP 10 report graph

Stuart McLachlan stuart at lexacorp.com.pg
Mon Apr 14 05:59:11 CDT 2003


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.





More information about the AccessD mailing list