How do I update nulls to zeroes?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

svasquez - 05 Jan 2005 23:31 GMT

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!

Reply to this Message

Ken Snell [MVP] - 05 Jan 2005 23:33 GMT

UPDATE MyTableName
SET MyFieldName = 0
WHERE MyFieldName Is Null;

Signature

Ken Snell
<MS ACCESS MVP>

>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
[quoted text clipped - 4 lines]
>
> Thx!

Reply to this Message

Douglas J. Steele - 05 Jan 2005 23:46 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

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

Reply to this Message