John Eget
joeget at vgernet.net
Mon Apr 14 04:04:34 CDT 2003
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030414/43e7c147/attachment.html>