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!
 
UPDATE MyTableName
SET MyFieldName = 0
WHERE MyFieldName Is Null;
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Design Table to show "Null" or "0" for Blank fields 4
To Zero or not to Zero 5
Convert zero-length string or blank cell to null 3
Show zeros for null in crosstab query 1
Find Replace values when they are not null 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
IIf statement in query, Null value change to "0" 2
Dmax in an Update Query 1

Back
Top