Hello, do do I pick a specific price point in Access 2007? For example, we are in the long distance telephone industry have have a pool of carriers that service area codes. I would like a query that says "show the third cheapest price for Area Code 562.
In this case the result would be: 562,PBELL,0.09
I'm only familiar with the First and Max expressions, so I can only see the cheapest and the most expecnsive... I am trying to see the second cheapest or the fifth cheapest etc.
|562 |ATT |0.05 |
|562 |VZN |0.03 |
|562 |SPRNT |0.15 |
|562 |PBELL |0.09 |
|562 |MJCK |0.11 |