?
Solved

MS ACCESS UPDATE

Posted on 2014-12-08
7
Medium Priority
?
175 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

750 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