Referencing a previous record

[knewt99]

Does anyone know of a way to compare contents of a field to the contents of the same field in the previous record?

I'm having trouble employing Get(RecordNumber) since the record number remains constant and doesn't change when I sort. I know it should not work like this but it does. Any ideas?

[Raybaudi]

Case(

yourField = GetNthRecord( yourField ; Get( RecordNumber) - 1 ) );

...do something;

""

)

result UNSTORED

[LaRetta]

Small things ...

Case(

YourField = GetNthRecord ( YourField ; Get( RecordNumber ) - 1 ) ;

... do something

)

There was an extra parenthesis. Also, if you want a null default, you don't need to specify it.

:wink2: