Remove single quote

[Jon R]

Using a query I am trying to remove the single quote from the
following example of numerous text fields in a table: AA -5.25"-AAA-
K. Using the following replace function: No
Quote:Replace([PART_NUM],""","") I am receiving the error message
"The expression you entered has an invalid string. A string can be up
to 2048 characters long including opening and closing quotation
marks." The table was imported in from Excel.
Thanks in advance.
Jon R

 

[storrboy]

Using a query I am trying to remove the single quote from the
following example of numerous text fields in a table: AA -5.25"-AAA-
K. Using the following replace function: No
Quote:Replace([PART_NUM],""","") I am receiving the error message
"The expression you entered has an invalid string. A string can be up
to 2048 characters long including opening and closing quotation
marks." The table was imported in from Excel.
Thanks in advance.
Jon R

Instead of replacing " , try replacing Chr$(34)

 

[Jon R]

Using a query I am trying to remove the single quote from the
following example of numerous text fields in a table: AA -5.25"-AAA-
K. Using the following replace function: No
Quote:Replace([PART_NUM],""","") I am receiving the error message
"The expression you entered has an invalid string. A string can be up
to 2048 characters long including opening and closing quotation
marks." The table was imported in from Excel.
Thanks in advance.
Jon R

Instead of replacing " , try replacing Chr$(34)

That did it - thank you.