I'm trying to compare the value with the current record against
the next or previous value. I want to do this for all the rows in the table.
I have been using the For Loop to go through each row but don't know how to get the previous/next row to compare.