title: Access SQL - if/then in update query
body: <p>I have table "SPPB" with fields:</p>
  
  <p>Total
  Status</p>
  
  <p>I need to update the Status field to either 1 or -9 depending on the value in the Total field. I.e., if Total is null, then Status is -9. If Total is not null, then Status is 1.</p>
  
  <p>I'm having trouble with syntax in Access...</p>