send2iwan wrote:

> hi all,
>
> i want to make query like this.
>
> table name=mutasi
>
> id transdate debet kredit saldo
> == ========== ===== ====== =====
> 10 10/01/2009 10000 10000
> 20 10/05/2009 250 10250
> 30 10/30/2009 5000 5250
>
> how to make the query espesialy for field saldo?
> everyday records increase 50-200 records.
>
> thanks.
> Iwan
>

If I were you, I would do it on the client side, usually report
generators have something like "Running Total" variables.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br