Maybe I'm missing something, but that doesn't seem to be doing the same thing at all...

Your code looks like it's storing the first record's field, then just scanning through the rest of the table. How does that get me the previous and next record for each record?

Thanks,

Michelle

>Hi, Michelle!
>
> Yes you can, just some programming tricks. See code sample below, in bold - differences
>
>
>
>if !eof()
> lcPrev = MyField
> SKIP
> SCAN REST && scan from current position till the end
> lcNext = MyField
> < do stuff here using current record plus the stuff gathered from other
> records >
> lcPrev = MyField
> ENDSCAN
>endif
>
>HTH.