error in my DoCmd.RunSQL statement

[cgclower]

What is wrong with my SQL statement? I'm betting it's something simple, like a quote in the wrong place or something, but I can't figure it out.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

DoCmd.RunSQL "UPDATE Table1 SET Table1.Field2='Deleted', WHERE Table1.Field1=" & variable1

<o></o>
Thank you in advance!

 

[alansidman]

This might help

http://www.fontstuff.com/access/acctut15.htm

Alan

 

[xenou]

There should not be a comma after 'Deleted'

 

[cgclower]

Yup, it was the extra comma. Thanks for the help, and for the link too!