DOCMD.RunSQL("Update mytable Set myfield = "FRED" WHERE myfield2 <> 9 ")
DOCMD.RunSQL("Update mytable Set myfield = 'FRED' WHERE myfield2 <> 9 ")