Solved

MS ACCESS UPDATE

Posted on 2014-12-08
7
167 Views
Last Modified: 2014-12-08
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
0
Comment
Question by:lux sat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40487386
here is the SQL statement for the update query

Update Candidate Set  Comments=Notes
0
 

Author Comment

by:lux sat
ID: 40487415
Rey:

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

Author Comment

by:lux sat
ID: 40487418
Rey:

When I try to run what should I do for the message box asking me to Enter Parameter Value for Notes
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40487426
try this

Update Candidate Set  Comments=[Notes]

and make sure that the field name [Notes] is correct
0
 

Author Comment

by:lux sat
ID: 40487436
Still getting that message box.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40487443
upload a copy of your db
0
 

Author Comment

by:lux sat
ID: 40487462
okay It worked. I left a character! Thanks for your help Rey!
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question