I WANA TO USE THE 2 FIELDS VALUE OF 3 PREVIOUSE RECORD IN A FORMUL OF CALCULATON FIELD IN A RECORD OF THE SAME TABLE. WHAT DO I MUST DO (IN FORMULE OF CALCULATION)?

Hi

sure you coud use the new GetNthRecord function.

But, for an exact answer, I need to know:

if there are only 3 records, what type of calc do you want ?

Do you want: (this is only an example)

GetNthRecord(field1;1)+ GetNthRecord(field1;2)+ GetNthRecord(field1;3)+ GetNthRecord(field2;1)+ GetNthRecord(field2;2)+ GetNthRecord(field2;3) ?

Please don't post in ALL CAPS.

i havent this function (GetNthRecord) in fmpro 7. and there arent only 3 records here i wana use 3 previously entered record in my calc

"I WANA TO USE THE 2 FIELDS VALUE OF 3 PREVIOUSE RECORD IN A FORMUL OF CALCULATON FIELD IN A RECORD OF THE SAME TABLE. WHAT DO I MUST DO (IN FORMULE OF CALCULATION)?

[color:red]This Post: FM Version: 8 Platform: Windows XP"

This was your firt post !

With 7 you have to make a script...post your file, please !