Find and Replace operation

#1 (**permalink**) 04-Nov-2005, 15:20 PM

I need to find a field with empty cells and replace them with value "0". But
from the "edit" --> "find/replace" can only find an existing value (not empty
cell) to replace. Anyone know how to solve it?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6659-find-and-replace-operation.html

thank you

*

#2 (**permalink**) 04-Nov-2005, 15:20 PM

i would write an update query. open a new query, choose your table and double
click the field you want to update with 0 to insert it into the query. On the
standard menu, click on "Query" and choose "Update Query". In the "critera"
box type Is Null, in the "update to" box, type 0 and run the query.

"frank" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6659

> I need to find a field with empty cells and replace them with value "0". But
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6659
> from the "edit" --> "find/replace" can only find an existing value (not empty
> cell) to replace. Anyone know how to solve it?
>
> thank you