title: Setting a default value in a blank field in an Access query
body: <p>This may have been answered elsewhere, but I can't find it!</p>
  
  <p>I'm combining 2 queries from different sources onto a single query for calculation and reporting purposes.  Fields which are not common to both sources show as blank if there is no data, and can't then be used in arithmetic.</p>
  
  <p>I want to set a default of zero where blank, instead of having to knife and fork the query into another table and run an update query over all the blank fields.</p>
  
  <p>There's got to be something simpler!  HELP!</p>