Update a field with no value

[Torsan]

How do I update an cell with no value (not even zero) to have a zero?

In fox pro I used ISBLANK, but I can't find a similar function. I tried this one:

IsMissing([Volume]![Omsetning])

But it only finds the zeros. Note, the field is numeric.

I need this to work, since the average of the field gives a wrong figure when I have empty cells.

Thanks

 

[edtab]

Try the IsNull function.

 

[Torsan]

IsNull is not doing it.

The IsNull does not work, which I find hard to understand.
Again, the field is empty and need a "zero"

 

[FoFa]

If you are trying to update a column to zero basically the query would be:
UPDATE MyTableName
SET MyColumn = 0
WHERE MyColunm IS NULL

 

[Torsan]

Thanks

That did it!!

Thanks..