<div>
here is the SQL statement for the update query<br />
<br />
Update Candidate Set &nbsp;Comments=Notes
</div>


here is the SQL statement for the update query

Update Candidate Set  Comments=Notes

<div>
Rey:<br />
<br />
When I try to run when should I do for the message box asking me to Enter Parameter Value for Notes
</div>


Rey:

When I try to run when should I do for the message box asking me to Enter Parameter Value for Notes

<div>
Rey:<br />
<br />
When I try to run what should I do for the message box asking me to Enter Parameter Value for Notes
</div>


Rey:

When I try to run what should I do for the message box asking me to Enter Parameter Value for Notes

<div>
Still getting that message box.
</div>


<div>
okay It worked. I left a character! Thanks for your help Rey!
</div>


okay It worked. I left a character! Thanks for your help Rey!

<div>
<div class="content wysiwyg-content">
I have a table named &quot;Candidate&quot; in MS Access.<br />
<br />
I have the following columns<br />
Notes<br />
Comments<br />
I need to update the Comments column with the content from Notes<br />
I have about 1000s of records in this table.<br />
<br />
Please help with an update statement in ACCESS
</div>
</div>


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

MS ACCESS UPDATE

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.