My records have 52 fields on the layout - numbered 1 through 52.
At the end of 52 weeks, some of the fields will have data, some will not.
I need to be able to go through all the fields, find the last 3 fields that have data and store that data.
I will then delete all the data in all the fields - (so I can start over).
I then need to take the stored data and put them in fields 1, 2 and 3.
I have no idea where to begin this script. Does anyone have any ideas?