Avatar of daisypetals313
daisypetals313
Flag 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
Microsoft Access

Avatar of undefined
Last Comment
daisypetals313

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Robert Sherman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rey Obrero (Capricorn1)

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] & ""<>""
daisypetals313

ASKER
Perfect, thanks!!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck