Find and Replace operation

F

frank

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?

thank you
 
M

Megan

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.
 
Top