We help IT Professionals succeed at work.

Merge Code Comments with Code

rtod2
rtod2 used Ask the Experts™
on
I want to merge the contents of the code comments field so that it appears above the associated code in the code field.  This is intended in order to get rid of a table column "code comments" that will no longer be needed once the merge has taken place.

Assistance is greatly appreciated.
ChartInd1.12.accdb
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
run this query

UPDATE StudyDetails SET StudyDetails.[CODE] =IIF([CODE COMMENTS] & ""="",[CODE],[CODE COMMENTS] & Chr(13) & Chr(10) & [Code];

Open in new window

Top Expert 2016

Commented:
missing ) at the end
UPDATE StudyDetails SET StudyDetails.[CODE] =IIF([CODE COMMENTS] & ""="",[CODE],[CODE COMMENTS] & Chr(13) & Chr(10) & [Code])

Open in new window

Author

Commented:
OK,
Forgive my ignorance.  I've never run a query this way.  How do I do that?
Top Expert 2016
Commented:
open the db and run query1

create a copy of the table first before running the query1
ChartInd1.12.accdb