Hi!
I have a table that have a datetime column with a by... and I want another column with count of people..but while the datetime grows i want the other column to sum the cnt of the row before plus the new cnt of the row..
ie
datetime people <--cnt of people in that datetime
2009/12/19 3
2009/12/20 5 <---3 from the last row and 2 more from this row
2009/12/21 10 <---5 from the last row and 5 more from this row

Thanks in advance

This message has been edited. Last edited by: Kerry,

Hi,

Is this something that you are looking for?
It basically append the count on the BY.

Best Regards,

Jimmy Pang

TABLE FILE EMPDATA
SUM
CNT.PIN AS 'PIN'
BY DIV
ON TABLE HOLD AS HLDCNT
END

DEFINE FILE HLDCNT
ASDF/D12.2 = ASDF + PIN;
END

TABLE FILE HLDCNT
PRINT DIV
ASDF
END

quote:

I have a table that have a datetime column with a by

Take a look at this..

  
TABLE FILE CAR
PRINT COUNTRY MODEL CAR SEATS 
AND COMPUTE T1/I5 = IF COUNTRY NE LAST COUNTRY THEN SEATS ELSE SEATS + T1 ;
BY COUNTRY
END

Or simply:

TABLE FILE CAR
SUM SEATS 
AND COMPUTE ROLLING_SEAT_CNT/I9 = LAST ROLLING_SEAT_CNT + SEATS ;
BY COUNTRY
END

THANK YOU So MUCH !!!
that did the trick