Hi,
Having problem in finding the last modified record.

Ex:

Values getting from the master file is below.

no name status action date
1 kamesh 6 create 01/10/05
1 kamesh 6 modify 01/11/05
1 kamesh 6 modify 01/12/05
1 kamesh 6 modify 01/13/05
1 kamesh 6 approve 01/13/05

The output has to be look like below.
output
------
1 kamesh create 01/10/05
1 kamesh modify 01/13/05
1 kamesh approve 01/13/05

If I tried using FST or LST by SUM the records, the status getting added for modify. Can anyone suggest me how we can solve this problem?

Thanks
Kamesh

Try a table request SUM fields BY no BY name BY status BY action BY HIGHEST date

Had a problem when we sum the records all the numeric fields are getting added. I solved it by change that numeric field in to alpha. Now it's seems working.

Thank's for the reply.

Hellow from Japan.
I am Zushi.
How is the following..

TABLE FILE modify_records
PRINT no name status
BY action
BY date
ON TABLE HOLD AS HOLD0001
END
TABLE FILE HOLD0001
SUM no name status action LST.date
BY action
END

Or simply

TABLE FILE filename
WRITE
FST.numeric_field1 AS numeric_field1
etc.
BY no
BY name
BY TOTAL date NOPRINT
BY action
BY HIGHEST 1 date
END

I think so.

DEFINE FILE filename
WSEQ/I3=WSEQ+1;
END
TABLE FILE filename
SUM CNT.ACTION NOPRINT
BY NO
BY NAME
BY ACTION
PRINT WSEQ
DATE
COMPUTE WCNT/I3=IF NO|NAME|ACTION NE
LAST NO|LAST NAME|LAST ACTION
THEN 1 ELSE WCNT2+1; NOPRINT
BY NO
BY NAME
BY ACTION
WHERE TOTAL C1 EQ WCNT
ON TABLE HOLD
END
TABLE FILE HOLD
PRINT NO
NAME
ACTION
DATE
BY WSEQ NOPRINT
END

Good Luck!