Solved

MS ACCESS UPDATE

Posted on 2014-12-08
7
142 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
  • 4
  • 3
7 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
here is the SQL statement for the update query

Update Candidate Set  Comments=Notes
0
 

Author Comment

by:lux sat
Comment Utility
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
Comment Utility
Rey:

When I try to run what should I do for the message box asking me to Enter Parameter Value for Notes
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
try this

Update Candidate Set  Comments=[Notes]

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

Author Comment

by:lux sat
Comment Utility
Still getting that message box.
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
upload a copy of your db
0
 

Author Comment

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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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.
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.

762 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

11 Experts available now in Live!

Get 1:1 Help Now