update numeric field with Null value

Question

How can I update a numeric field with Null value if value is 0. I try the following but It does not work

UPDATE tblInternalIncident SET tblInternalIncident.LossValue = Null

WHERE tblInternalIncident.LossValue=0

Thks

Answer 1

I created a table with a field to match yours and entered 0 into some of the records. I copied you SQL statement into a query SQL view and ran it. The results were exactly as expected. Any records with a 0 had the field values replaced with null.

Are you sure the value is 0 in your records?

What do you see with this query?

SELECT tblInternalIncident.*

FROM tblInternalIncident

WHERE LossValue=0;

Answer 2

I means I use the update query with that syntax, but when I run the query, nothing happen

I am not sure if it allow Null. The field is not required to insert value, so I can leave it empty when inputting value. Is that the same meaning with "allow Null" ?

Answer 3

What do you mean by "does not work"? Does the field allow Nulls?