query areas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top