At 11:21 AM 30/07/2008, you wrote:

>The RUNSUM function calculates the sum of values for a column in a
>running total. The syntax is as follows:
>RUNSUM(column_reference or expression. We used RUNSUM to sum all the
>values in the specified column in a continuous running total. The RUNSUM
>function is identical to the SUM function except for the fact that it
>does not reset itself when sub-totalling.
>in my case I use RunSum(1), combined with order by I get exactly what I
>need to rank my rows.

So -- *what column is it totalling on* and how does the running total relate to your ordering criterion (Price)?

Before you answer, please read the following article:
http://www.catb.org/~esr/faqs/smart-questions.html

^ heLen