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] & "'")