title: MS access check column value and change another
body: <p>I have an ms access database with some yes/no columns I want to check and set the value of a third. The statement should be something like the following</p>
  
  <pre><code>if !col1 &amp;&amp; !col2:
           col3 = no
  else:
      col3= yes
  </code></pre>
  
  <p>I keep searching but don't really understand vba and can't find what I need .. Mostly a segment of an answer to something else that I cant make work. Currently trying to create it in the "module" section is that even right? Would be best if this could be done automatically as those columns are changed or maybe run once and do all rows. Please help me get on the right track, any help greatly appreciated. </p>