|
I think you want to take a look at the "TOP N" clause as in:
SELECT TOP N WHERE ...
The catch is that you have to know the value of N before hand. There is probably a way to use subqueries to put it together. My MS Access is pretty rusty. Anyway, if you create the TOP N query first and then use it as a source for a second query, you should be able to compute the sum that you want.
__________________
It takes 2 points to draw a straight line, but at least 3 points to draw a conclusion.
|
Linear Mode
