Euricho,
This does what you want:
Create Cursor client (Id I, Date D, Value I)
Insert Into client Values (1, {01/01/2001}, 100)
Insert Into client Values (1, {02/01/2001}, 50)
Insert Into client Values (1, {03/01/2001}, 100)
Insert Into client Values (2, {01/01/2001}, 200)
Insert Into client Values (3, {15/01/2001}, 300)
Select ;
C1.id, ;
C1.Date, ;
C1.Value, ;
sum(C2.Value) as balance;
from Client C1 ;
join Client C2 on C1.id=C2.id ;
and C1.date>=C2.date ;
group by C1.id, C1.date
Dave Crozier
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Eurico Chagas Filho
Sent: 30 June 2008 13:17
To: 'ProFox Email List'
Subject: Report values
Hi
I have this;
Client dtaMov Value
1 01/01/01 100
1 02/01/01 50
1 03/01/01 100
2 01/01/01 200
3 15/01/01 300
but I need to do something like this;
Client dtaMov Value
1 01/01/01 100
1 02/01/01 150
1 03/01/01 250
2 01/01/01 200
3 15/01/01 300
The value must add the last value each cycle.
How can I do it ?
TIA, E.
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
