| | |
|
|
|
Null to Zero, Access 97 |
|---|
| message from Dave O'Brien on 17 May 2004 |
Can anyone tell me how I can create an update query to replace blank
numeric fields in my table to zeros?
|
| Douglas J. Steele replied to Dave O'Brien on 17 May 2004 |
UPDATE MyTable
SET MyField = Nz(MyField, 0)
or
UPDATE MyTable
SET MyField = 0
WHERE MyField IS NULL
|
| Wayne Morgan replied to Dave O'Brien on 17 May 2004 |
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])
|
|
Archived message: Null to Zero, Access 97 (Microsoft Access Forms)
