I have created a query which has the fields - Alarm Type, which is sorted ascending, Node Name, and Alarm Count (By Node Name) which is sorted descending. The purpose of the query is to demonstrate the node which produced the highest type of each alarm. The query does this fine but, for my report I would like to just show the top 10 of each alarm type without having to split up the query at all. Is this possible??? I may need to hence that I already know how to get a top ten of all records, but I would like to get a top ten of each alarm type within the query results. This could be 35 different alarm types with more than ten results per alarm type. I would just like to demonstrate the first ten of each alarm type seeing as i have already sorted the count descending. CAn anyone help???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Top ten in a group by query (2)
- Thread starter Mugs
- Start date
Similar threads
- Question
- Locked
- Question
- Locked
- Question