Hi Hilmar.

What I am realy after is an accumulating balance, rather than just one total.

Regards,

Gerard


>It would be simpler to just show the final total in a separate TextBox, but I don't know whether this would be appropriate for you.
>
>>Hi.
>>Is there any one command (In aGrid or perhaps a SQL option) which will show an accumulating balance .
>>
>>e.g. as follows:
>>
>>Cust Invoice Amt Cumulative
>>001 100.00 100.00
>>023 300.00 400.00
>>022 800.00 1200.00
>>
>>Above would be displayed in a Grid.
>>I know I could write a piece of code to populate the third column but was wondering if anybody had come up with some other one line/command variation ?
>>
>>Regards,
>>
>>Gerard