Copy Field Contents

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I am using MS ACCESS XP. I want to copy all the contents
of one field in a table to another blank field in the same
table. How can this be done, and please explain in simple
English even a newbie could understand? Thanks.
 
Hi,


UPDATE tableNameHere SET blankFieldNameHere = fieldWithValues


in a SQL view of a new query... BUT, for sure, before making any
experimentation, make sure you work on a copy (or have a good backup) since
those process may modify a LOT of your data, very quickly.


Hoping it may help,
Vanderghast, Access MVP
 
while looking at the table, click on the column name. The
entire column should be highlighted, click copy. Then
click on the column header for the field you want to paste
to. The entire column should be highlighted, click paste.
 
Back
Top