Updating a Number field to NULL

[Guest]

Hi all,

I like to know if it's possible to update a numeric field in Access and set
its value to NULL (this is possible in SQL Server)? If yes, how to do it.
Thanks in advance.

Roy

 

[Allen Browne]

Sure. Run an update query:
UPDATE MyTable SET MyTable.MyField = Null;