Access 97: Append Column and Copy Data Into Existing Table

[beaudetious]

I would like to append a new column to an existing table in Access 97. Then I'd like to copy existing data into the new column. The data is in the same table.

For instance:

Field1 AppendedField
1 1
2 2
. .
. .
n n

Once the new field is appended, I'd like to copy over the values in Field1 into the new column. I don't want to append new rows which is all I seem able to do.

I've got the ALTER TABLE SQL working fine (I can add a new column), but what about the copying part. What's the SQL for that?

Axe

 

[benjamenus]

update TABLENAME
set TABLENAME.APPENDEDFIELD=TABLENAME.FIELD1;

 

[beaudetious]

Thanks. I just worked that out a few minutes ago. I appreciate your help, however.

 

[dannyocean]

Could you please share your process for appending the column. This would come in very handy for me with projects I do.

Thanks,

Danny

 

[benjamenus]

Create a macro and use the RunSQL action. The SQL statement is

ALTER TABLE [TABLENAME] ADD COLUMN [COLUMNNAME] TEXT(50)

TEXT(50) is the data type, so that could be DATE, MEMO, etc