D Dave O'Brien May 17, 2004 #1 Can anyone tell me how I can create an update query to replace blank numeric fields in my table to zeros?
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 May 17, 2004 #2 The SQL will look something like: UPDATE MyTable SET MyField = Nz(MyField, 0) or UPDATE MyTable SET MyField = 0 WHERE MyField IS NULL
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 May 17, 2004 #3 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])
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])
