K
kevcar40
hi
i have a query that returns the top 5 areas giving a problem
Area 1
Area 2
Area 3
Area 4
Area 5
my table has the fields area, reason and component
there are as many as 20 areas
my first query counts the areas returning area and quantiny
what i want to do is return the top 3 faults against each area
ie area 1 fault 1
area 1 fault 2
area 1 fault 3
any idaes
thanks kevin
i have a query that returns the top 5 areas giving a problem
Area 1
Area 2
Area 3
Area 4
Area 5
my table has the fields area, reason and component
there are as many as 20 areas
my first query counts the areas returning area and quantiny
what i want to do is return the top 3 faults against each area
ie area 1 fault 1
area 1 fault 2
area 1 fault 3
any idaes
thanks kevin