Updating multiple fields using scripts
In our marketing database we have fields to keep track of calls (and notes on those calls). The fields are set up as Call Date" 1-25 and "Notes" 1-25. When the database closes, I want a script to scan the "Call Date1" field in all records and if it is newer than "Call Date2," move data from "Call Date1" field to the "Call Date2," move "Call Date2" data to "Call Date3" field, etc., as well as move data from "Note1" to "Notes2", and "Notes2" to "Notes3," etc.
The script(s) I have written thus far only updates one record instead of all the ecords in the database that match this criteria.