MS ACCESS UPDATE

I have a table named "Candidate" in MS Access.

I have the following columns
Notes
Comments
I need to update the Comments column with the content from Notes
I have about 1000s of records in this table.

Please help with an update statement in ACCESS
lux satTechnical ConsultantAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this

Update Candidate Set  Comments=[Notes]

and make sure that the field name [Notes] is correct
0
 
Rey Obrero (Capricorn1)Commented:
here is the SQL statement for the update query

Update Candidate Set  Comments=Notes
0
 
lux satTechnical ConsultantAuthor Commented:
Rey:

When I try to run when should I do for the message box asking me to Enter Parameter Value for Notes
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
lux satTechnical ConsultantAuthor Commented:
Rey:

When I try to run what should I do for the message box asking me to Enter Parameter Value for Notes
0
 
lux satTechnical ConsultantAuthor Commented:
Still getting that message box.
0
 
Rey Obrero (Capricorn1)Commented:
upload a copy of your db
0
 
lux satTechnical ConsultantAuthor Commented:
okay It worked. I left a character! Thanks for your help Rey!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.