Top N items per group

[babak]

I want the top 3 "Downtime" for each "Line". The table is called "Top 3 Downtime" and I put this in the criteria of Downtime.

In (Select Top 3 [Downtime] From [Top 3 DownTime] Where
[Line]=[Top 3 DownTime].[Line] Order By [Downtime] Desc)

For some reason, this is only returning the top 3 "Downtime" without taking line into consideration. Does anyone know what is wrong with the code?

[June7]

Review http://allenbrowne.com/subquery-01.html#TopN