Need to limit the number of items in a bar graph 1

[irethedo]

I have a report that displays a bar graph of bad parts which are sorted in descending order of the part number with the most failures but I also want to limit the number of failed parts displayed to the top 5 parts. The row source of my chart looks like this:

----------
SELECT ([Part Number]) AS Expr1, (Count([Part Number])) AS [Bad Parts] FROM [Bad Part qry] GROUP BY [Part Number] ORDER BY (10000- (Count([Part Number])));
----------

How can I limit the number of entries in the bar graph to display the 5 most failed parts?

Thanks in advance!

 

[dhookom]

How about:

SELECT TOP 5 ([Part Number]) AS Expr1, (Count([Part Number])) AS [Bad Parts] 
FROM [Bad Part qry] 
GROUP BY [Part Number] 
ORDER BY (10000- (Count([Part Number])));

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[irethedo]

Thanks Duane- You sure made that one easy!