Null to Zero, Access 97

D

Dave O'Brien

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

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
 
W

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])
 
Top