Multiple Group Top Value (1 Viewer)

Hello -

I have a table that has fields named Category, SubCategory1 and SubCategory2. I would like to create a query that will select the top three values in each of these fields (i.e. The top three categories are X, Y, Z. Of X, Y, Z: A, B, C are the top three subcategory1's. And finally, of A, B, C: 1, 2, 3 are the top three subcategory2's.

I have tried the subquery samples I have found but with no luck. I can seem to make it work for the first two levels but not the third. :banghead:

Would someone be able to help me figure this out?

Thank you in advance!

Huh? Can you demonstrate your issue with data please? Give us 2 sets:

A. Starting sample data from your table. Include table and field names and enough data to cover all cases.

B. Expected results of A. Show what data you hope to end up with when you feed in the data from A.

Again, 2 sets of data to demonstrate what you want to occur.