Update query help

[Access_help_rob]

Hey there if i wanted to do an update query to replace every field which has a blank value with a 0 wot would i type and where would i type it
thanks
rob

 

[FoFa]

Depends on what you call a "blank" value. Most likely it is a NULL value. create an update query. Drag your column down you want to update. In the UPDATE TO column put 0 (I am assuming it is numeric, "0" if string). In the criteria put IS NULL.
That should do it unless you have spaces or something like that (if a string).