How can I find the next value in a date field? I want to update a field called VERSION, based on the date an item was approved OR based on its APPROVDATE. The record would look like this: ITEM APPOVDATE VERSION 783 3/25/2008 1.01 783 4/26/2008 1.02 783 4/26/2008 1.02 783 5/17/2008 1.03 783...