Setting a number field to Null instead of zero 0 in an update query

[ben_jamin]

Hello,
I have an update query that calculates a value based on the value in another field. However, if the value in the other field is 0, the calculation does not work because you get division by zero 0. When the value in the other field is 0, I need the update query to put a null value in the calculated field. It cannot put a zero 0 there because a zero 0 has other meanings and would be incorrect. How can I set the calculated number field to be either blank or null or erased when the other field is 0? Thank you.

[John_G]

It would depend on the "required" setting for the field in the table. If Required = Yes, then you can't set it to Null.

If required = No, then you could use an Update query with an Iif expression: iif(FieldA = 0, Null, fieldB / fieldA)

to update the field.