Solved

how to replace a character in a table in access 2013

Posted on 2014-01-11
5
918 Views
Last Modified: 2014-01-12
hi

how can i change - with sql string or vba-  a character in a table to another character, for example i want that in my product table every time that it's find a Apostrophe to change it to a Quotation mark. something like this
replace (ProductName,"'",""")

Open in new window

. but i don't know how update a field with replace function on a query.
0
Comment
Question by:bill201
  • 2
  • 2
5 Comments
 
LVL 40

Expert Comment

by:Sharath
ID: 39774367
UPDATE YourTable
SET replace (ProductName,"'",""");
0
 

Author Comment

by:bill201
ID: 39774376
it's not working

i get an error message syntax error with in update statement
0
 
LVL 40

Expert Comment

by:Sharath
ID: 39774390
Can you post the exact error message. It is just a simple UPDATE statement.

Reference: http://msdn.microsoft.com/en-us/library/office/bb221186(v=office.12).aspx
0
 

Author Comment

by:bill201
ID: 39774403
hi

this is the code
UPDATE IskitReportTemp
SET replace (ProductName,"'",""");

Open in new window


and the error message it's like i wrote "syntax error with in update statement" i don't get more details
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39774411
It is:

UPDATE
    IskitReportTemp
SET
    ProductName = Replace([ProductName],"'","""");

/gustav
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Creating and Managing Databases with phpMyAdmin in cPanel.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

920 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