Code Forums - View Single Post

technobard · 03-11-2005, 09:45 AM

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.

03-11-2005, 09:45 AM	#2 (permalink)
technobard Centurion Nova Prime Join Date: May 2002 Location: Oak Park, IL (USA) Posts: 287	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.