B
Bill - ESAI
Hi All
I'm need to copy the Project Descriptions from the back up table
(Projects_Old) to my active table. I messed up and accidentally changed my
ProjectDescription field from a Memo to a 255 text which truncated all my
descriptions. Now I need to recover the ones I can from my back up. Both
table structures are identical and the ProjectID is the unique key in both.
This is my attempt so far
UPDATE Projects
SET Projects.ProjectDescription = (SELECT Projects_Old.ProjectDescription
FROM Projects, Projects_Old WHERE Projects.ProjectID=Projects_Old.ProjectID)
WHERE Projects.ProjectID = (SELECT Projects_Old.ProjectID FROM Projects,
Projects_Old WHERE Projects.ProjectID=Projects_Old.ProjectID);
Any pointers would be greatly appreciated.
Bill
I'm need to copy the Project Descriptions from the back up table
(Projects_Old) to my active table. I messed up and accidentally changed my
ProjectDescription field from a Memo to a 255 text which truncated all my
descriptions. Now I need to recover the ones I can from my back up. Both
table structures are identical and the ProjectID is the unique key in both.
This is my attempt so far
UPDATE Projects
SET Projects.ProjectDescription = (SELECT Projects_Old.ProjectDescription
FROM Projects, Projects_Old WHERE Projects.ProjectID=Projects_Old.ProjectID)
WHERE Projects.ProjectID = (SELECT Projects_Old.ProjectID FROM Projects,
Projects_Old WHERE Projects.ProjectID=Projects_Old.ProjectID);
Any pointers would be greatly appreciated.
Bill