title: How to replace blank (null ) values with 0 for all records?
body: <p>MS Access: How to replace blank (null ) values with 0 for all records?</p>
  
  <p>I guess it has to be done using SQL. I can use Find and Replace to replace 0 with blank, but not the other way around (won't "find" a blank, even if I enter [Ctrl-Spacebar] which inserts a space.</p>
  
  <p>So I guess I need to do SQL where I find null values for MyField, then replace all of them with 0.</p>