Need twp single quotes somewhere

[penwood]

Need Different quotes after change to TEXT

i have this qry field that works fine if my formulaID is a NUMBER field.

UomUsageSum: Val(Round(DSum("nz([UomUsage])","[tblFormulaDetail]","[FormulaID] = '" & [FormulaID] & " "),4))

However, i just changed the formulaID to TEXT in my table.

So I think i need different quotes somewhere at the criteria end of this qry calc because FormulaID is now TEXT.
how do i fix this at the end of the field?
thanks

 

[penwood]

Thanks alot. your calc works nicely. and thanks for the improvements too with explainations. that was so thoughtful.

penwood