Update Blank Feilds Access

[ukgimp]

I know this will be simple but I cannot seem to find the solution.

I have a column in an access db. I would like to to an update query and make all the ones which are blank into some other value. Its is the crieria of the sql that is stumping me.

Cheers in advance

[WebJoe]

UPDATE Table Set Field2BeUpdated = 'SomeValue' WHERE (Field2BeUpdated IS NULL or Field2BeUpdated = '')