Access update statement

Question

Trying to make all the dates from a column null except for 10/15/2012 in access here what I have so far.

Update tbl_ReleaseTracking Set 2nd_Ltr_Sent= null WHERE  2nd_Ltr_Sent <> #10/15/2012#

I get the error missing operator in query expression '2nd_LRT_Sent <> #10/15/2012#.

Answer 1

This will do what you want:

Update tbl_ReleaseTracking Set [2nd_Ltr_Sent]= null 
WHERE [2nd_Ltr_Sent] <> #10/15/2012#

Answer 2

Even though I'm not familiar with MS Access, I think that columns should not start with a number. Tried enclosing the column name with ``?