Updating table data

  • Thread starter Thread starter Eddy
  • Start date Start date
E

Eddy

Hey,

Can anyone tell me how I update data from one column into another in the
same table?

Then delete the contents from the column I have just moved the data from?

Sorry it may seem like a dumb question, but I cannot figure it out!!

Eddy
 
Perhaps the following will work. TEST IT on a COPY of your table.

UPDATE TheTable
Set Field1 = Field2,
Field2 = Null
 
Back
Top