Syntax Error when using Apostrophe

[PicoTTS]

Hi,

I have a formula in a query that tries to sum up all the values whenever the description matches. It works great except whenever the description contains an apostrophe and then I get syntax errors.

Is there any ways around this?

Quantity_Released: DSum("Quantity","Product Query","Description = '" & [Description] & "'")

[ranman256]

Done use Dsum, instead use a query that does the Sum.
no apostrophe error.

[CJ_London]

you need to replace the single quote with two single quotes using the replace function

......"Description = '" & replace([Description],"'","''") & "'"

[June7]

And if there is a quote mark in the text, really a nuisance. I do whatever I can to prevent use of quote marks in data, such as not using " to represent inches. Not if you intend to reference the field in any VBA code, as in your situation.

[ssanfu]

And note that "Description" is a reserved word in Access and shouldn't be used as an object name. Plus it is not very descriptive......

May change to something like "ProblemDesc", "GroupDesc", "TreatmentDesc", etc.......