How do I update nulls to zeroes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top