I have a table that has all the state 2 letter codes. The market mapping which will take the state two letter code and map the market. Such as AL will have multiple markets. AZ multiple markets. Then it has paper volumes for the year 2008.
I know how to get the top 25 paper volumes in descending order. But what I need is how to get the top 25 paper volumes in descending order per market mapping. When I run my non top 25 query, I get 14k rows back. I need to get the top 25 per market mapping and right now am doing it manually. I ascend my market mapping and descend my paper volumes. So right now it might look like this:
Market Mapping Region TaxID Paper Volume
Alabama Southeast 000000 200000
Alabama Southeast 111111 199900
Alabama Southeast 222222 190000
and so on. Alabama market mapping returns 2700 rows. I just want to take the top 25 of that market mapping. After the Alabama market mapping then it is Arizona. Now I can't simply do this by state two letter because the states have multiple market mappings. We do everything here by market mapping. So say for instance I have PA. Well PA is broken down into the market mapping of
E. Pennsylvania
W. Pennsylvania.
So I need the top 25 for each of the market mappings based on the top 25 highest paper volumes. I use MS Access and trying to figure out what exactly to put in my criteria to get my results.
Thanks!!!