Solved

MS ACCESS UPDATE

Posted on 2014-12-08
7
166 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 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

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.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

839 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