Copy Field Contents

[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.

 

[Michel Walsh]

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

 

[jason]

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.