Filling in empty fields with 0s

[Guest]

I am using the 'Replace' feature. I put in the

Replace - Is Null

With - 0

When it starts, you can see it fill in all the blanks with 0s, however, it
never finishes. It ends up telling me 'this database is not responding'.
Any reason why this would happen each and every time. I can do this in Excel
with the same data by exporting it and then having to import it back in.
There are around 85,000+ records.

Thanks.

 

[Guest]

First back up your data.

You can use update query to do this

UPDATE TableName SET FieldName = 0
WHERE FieldName Is Null

 

[Guest]

Thanks for your quick response.

When I ran the update query, it stated that it updated some 14,000
records/fields. However, when I went into the table they are still all
showing blank. I re-ran the update query again, however, this time it says
it has 0 records to update. It is acting like there are zeros in there, but
I don't see anything.

 

[Pieter Wijnen]

Your table accepts zero length values (ie Null or VBA.vbNullstring) -
Allways turn of ZLS for Fields - Check www.allenbrown.com for code
In the mean time modify your query to
UPDATE TableName SET FieldName = 0
WHERE FieldName Is Null Or FieldName=""

HTH

Pieter

 

[Pieter Wijnen]

... AND you might want to change the field to a numeric type field ...

Pieter

 

[Guest]

Ofer,

I tried this and it didn't work. I also tried Pieter's suggestion, no to
that also. However, what I was doing was trying to update 5 fields at the
same time. When I only update one field at a time, it works. Any reason why
it doesn't like to update multiple fields at a time?