Migrating Data between two Tables

[JTS25]

HI all,

I am working in a Table named ' Initiative Status', and this Table has two fields that hold comments ' Status Comments' & 'SOW Comments'. We have been told that the field 'SOW Comments' is being removed, and I have been asked to move all of the information that was in 'SOW Comments' into the 'Status Comments' field.

There are around 600 rows in this Table, that have 'SOW Comments' associated to them. Is there a way to do this migration, without having to work each item individually? Any help is greatly appreciated.

 

[Joe4]

Take a look at doing an Update Query.

You want to set the Criteria to update all record where the "SOW Comments" field is not empty, and you want to update the "Status Comments" field to be the combination of the two fields.

The SQL code of the query might look something like:

UPDATE YourTableName 
SET [Status Comments] = [Status Comments] & [SOW Comments]
WHERE [SOW Comments]<>"";