Getting the Quotes right

[aytee111]

I just can't seem to get the correct quotes in the right sequence.

I want to replace all single quotes with nothing (remove them).
Replace(NotesStr, "'", "")

Except that this is nestled inside a DoCmd.RunSQL - my table name is different each time, so I can't make a permanent query.
"UPDATE.....Replace(NotesStr, "'", "")...."

Anyone know how to figure this out?

[June7]

Replace(NotesStr, Chr(39), '')
or
Replace(NotesStr, '''', '')

[aytee111]

Oh yes, forgot about those ascii characters. Thanks.