How do I update nulls to zeroes?

S

svasquez

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!
 
D

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