Top 50 Records for each category

[mikesj]

I am trying to create a single query where I can show the top 50
records of each category. For instance I have 3 columns in my table

Name | State | Salary

I want to show the top 50 salaries in PA, NJ, DE, MD so a total of 200
should be on my list. I can only get it to show me the top 50 based on
all states, not broken down by state.

Thanks

 

[Allen Browne]

See:
How to Create a "Top N Values Per Group" Query
at:
http://support.microsoft.com/kb/210039/en-us

 

[mikesj]

Thanks!

See:
How to Create a "Top N Values Per Group" Query
at:
http://support.microsoft.com/kb/210039/en-us