Report Showing Only Top 10 (1 Viewer)

[chastst]

I have a query that gives me a listing of the count of times an equipment has failed. It is sorted from greates to least by failures. Is there a way for a report to only show me the top 10 in this list, and disregard the remaining 60 or so?

Thanks

 

[Rich@ITTC]

Hi Chastst

Here's an example form the Help file:

TOP n [PERCENT] Returns a certain number of records that fall at the top or the bottom of a range specified by an ORDER BY clause. Suppose you want the names of the top 25 students from the class of 1994:

SELECT TOP 25
FirstName, LastName
FROM Students
WHERE GraduationYear = 1994
ORDER BY GradePointAverage DESC;

So you would need to put in your fields/tables etc and change the SELECT to

SELECT TOP 10

HTH

Rich Gorvin

 

[skollager]

I think you can do this from the properties on the within the query. Try bringing up the query properties dialogue box and change the top values field from all to 10 etc. Then alpha sort z -a or vice versa to get your desired result.

[This message has been edited by skollager (edited 04-21-2001).]