rmccaslin 0 Newbie Poster

I have some accumulated error data organized by week. How can I write a query to pull the top 10 or top 10% for each week and show them in the same table? I will need it to be flexible enough that it will continue to function properly as I add data - in other words, I don't want to hard code in the existing weeks in the table.

Thanks in advance.