How do I update nulls to zeroes?

[Guest]

I have a table that contains nulls in some of the value fields and need to
update the null values to zeroes to be able to import this table into another
database. I tried to create an update query to update the master table, but
it did not work. Can you help?

Thx!

 

[Ken Snell [MVP]]

UPDATE MyTableName
SET MyFieldName = 0
WHERE MyFieldName Is Null;

 

[Douglas J. Steele]

Do you really have to change the values, or can you create a query and
export it? In your query, use Nz(MyField, 0), rather than MyField.