<div>
UPDATE YourTable<br />
SET replace (ProductName,&quot;'&quot;,&quot;&quot;&quot;);
</div>


UPDATE YourTable
SET replace (ProductName,"'",""");

<div>
it's not working<br />
<br />
i get an error message syntax error with in update statement
</div>


it's not working

i get an error message syntax error with in update statement

<div>
Can you post the exact error message. It is just a simple UPDATE statement.<br />
<br />
Reference: <a href="http://msdn.microsoft.com/en-us/library/office/bb221186(v=office.12).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/office/bb221186(v=office.12).aspx</a>
</div>


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 [http://msdn.microsoft.com/en-us/library/office/bb221186(v=office.12).aspx]

<div>
hi<br />
<br />
this is the code
<pre><code id="code-20-39774403-1">UPDATE IskitReportTemp
SET replace (ProductName,&quot;'&quot;,&quot;&quot;&quot;);</code></pre>
<br />
and the error message it's like i wrote &quot;syntax error with in update statement&quot; i don't get more details
</div>


hi

this is the code

UPDATE IskitReportTemp
SET replace (ProductName,"'",""");


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

<div>
<div class="content wysiwyg-content">
hi<br />
<br />
how can i change - with sql string or vba- &nbsp;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 
<pre><code id="code-10-28336361-1">replace (ProductName,&quot;'&quot;,&quot;&quot;&quot;)</code></pre>
. but i don't know how update a field with replace function on a query.
</div>
</div>


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 (CODE). but i don't know how update a field with replace function on a query.

how to replace a character in a table in access 2013

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.