If I could write the program in "Progress" it would say:
/* Proceedure Rollforward */
define variable set-year as integer.
for each record:
year = set-year.
field-2 = field-1.
field-1 = field.
field = "".
How would that work in an Access VBA module that is called by a menu button?