Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SCALE OF INTEREST-HIDE DATE WITH SUM=TO PREVIOUS DATE

Status
Not open for further replies.

Yann

IS-IT--Management
Jan 21, 2003
4
FR
HYE THERE?

I want to display a scale of interest from the foloowing datas :
for exemple------------------

[account] [dates] [POSITION ACCOUNT]
AAAAA 01/10/02 +100.00
BBBBB 01/10/02 -100.00
CCCCC 01/10/02 +100.00 =total 01/10/02=+100

AAAAA 02/10/02 -100.00
BBBBB 02/10/02 +100.00
CCCCC 02/10/02 +100.00 =total 01/10/02=+100

AAAAA 03/10/02 +110.00
BBBBB 03/10/02 +120.00
CCCCC 03/10/02 +130.00 =total 01/10/02=360

The result I expect-------------------------
[DATES ] [POSITION ACCOUNT/total] [NBR OF DAYS]
01/10/02 +100 2
03/10/03 +360 1


Thank you for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top