Link to home
Start Free TrialLog in
Avatar of daisypetals313
daisypetals313Flag for United States of America

asked on

Update Query to replace value of one column with another column (but not null values)

How would I create an Update Query to replace the values in the attached file as follows:

Column OLD will be replaced with values from Column NEW, but only when the value in NEW isn't null.

Thanks!
Sample.accdb
ASKER CERTIFIED SOLUTION
Avatar of Robert Sherman
Robert Sherman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
create a backup copy of table before running the query

update tablex
set [OLD]=[NEW]
where [NEW] is not null

or

update tablex
set [OLD]=[NEW]
where [NEW] & ""<>""
Avatar of daisypetals313

ASKER

Perfect, thanks!!