Solved

how to replace a character in a table in access 2013

Posted on 2014-01-11
5
894 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

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

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

747 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

10 Experts available now in Live!

Get 1:1 Help Now