Would that not create a third field? In a database that is already being used, I want to take data from field one and place it in field two while keeping the data that is already in field 2. Is this possible?

I should also say, I just want to do this once. And then I want the fields to go back to normal. The data dumped that occur did not do exactly what I wanted it to do and so now I am trying to rectify that.