Null to Zero, Access 97

[Dave O'Brien]

Can anyone tell me how I can create an update query to replace blank
numeric fields in my table to zeros?

 

[Douglas J. Steele]

The SQL will look something like:

UPDATE MyTable
SET MyField = Nz(MyField, 0)

or

UPDATE MyTable
SET MyField = 0
WHERE MyField IS NULL

 

[Wayne Morgan]

UPDATE Table1 SET Table1.Field1 = 0
WHERE Table1.Field1 Is Null;

Adjust the table name and field name to match yours. If there are spaces in
the name, each name with spaces will have to have brackets around it (i.e.
[Table 1].[Field 1])