Hi, I need to move a group of data from 1 field to another, within the same record. A change was made to a layout, that basically caused data to be entered in the wrong field on about 1000 records of a 3000 record database. Does anyone know an easy way to move the data from Field1 to Field2 on only 1000 of the records?

I am able to sort by DateEntered to isolate the 1000 records in a find. Is there someway to move just these 1000 from Field1 to Field2 without effecting the other 2000 records?

Find the records to be changed

Create this script:

Name it anything, maybe - Replace Field 2 with Field 1

Go to Layout [ original layout ]

Go to Record/Request/Page

[ First ]

Loop

Set Field [ Field 2 , Field 1 ]

Clear [ Field 1 ]

[ Select entire contents ]

Go to Record/Request/Page

[ Next, Exit after last ]

End Loop

HTH

Lee

That did the trick Lee! Thanks for the help!