Can anyone think of a simple way to grab a value from a field in the record immediately before and after the current record, without changing the current record? It has to respect the sort order as well.

It seems like it should be simple, but it's just not coming to me...

Thanks,

Michelle