Add fields and fill them

[kennetha]

Hi all,

I have created a database some months ago and I have added some fields recently. I would like to know how to fill the old fields with the new ones without going to paste in every cell

Thanks
Kenneth.

 

[Remou]

Perhaps you should try:
Microsoft: Access Queries and JET SQL Forum
forum701

 

[Thargy]

kennetha,

what's wrong with

update table kennetha
   set old_cloumn = new_column;

commit;

Regards

Tharg

Grinding away at things Oracular