How to remove nulls? 2

[tlove161]

I received a table with some nulls in many fields. I need to change all the nulls in the table to zero. Is there a way to accomplish this with a query? I tried to use the find and replace, but it will not search for nulls. Thanks.

 

[Zonie32]

you could create an update query. in criteria section enter "is null" and in the "update to" section type "0".

 

[PHV]

UPDATE yourTable
SET yourField = 0
WHERE yourField Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tlove161]

Thanks to both of you. An update query did it.