Posted on 2014-12-08
Last Modified: 2014-12-08
I have a table named "Candidate" in MS Access.

I have the following columns
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
Question by:lux sat
  • 4
  • 3
LVL 120

Expert Comment

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

Update Candidate Set  Comments=Notes

Author Comment

by:lux sat
ID: 40487415

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

Author Comment

by:lux sat
ID: 40487418

When I try to run what should I do for the message box asking me to Enter Parameter Value for Notes
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

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

Author Comment

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

Expert Comment

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

Author Comment

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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access 2016 5 53
making call from microsoft access to skype for business 5 42
Restoring a form to its default settings 3 26
User Level Security 6 34
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now