Greatest values question

[cokeblue8]

Hi everyone

This seems like a really simple problem, but I can't figure it out...

-I have a table that contains machine problems, and their duration times
-I made a query that filters the problems based on the date of occurance, and adds up the duration times for a specified problem for the date range

Question: How do I get it to display the top 5 (i.e. 5 with the longest duration) problems? Can the max function work for more than one record?

 

[neileg]

Question: How do I get it to display the top 5 (i.e. 5 with the longest duration) problems? Can the max function work for more than one record?

Believe it or not, you can use a top values query and set it for 5 values. Check in Access help for top values.

 

[cokeblue8]

works perfectly. thanks