title: Access DB query - need help updating certain records
body: <p>I have an access DB which we use to track tickets. Each ticket may have multiple occurrences because of different programming changes associated with that ticket. Each record also has a program_type field which is SVR or VB. Example:</p>
  
  <pre><code>123456 - SVR - SomeCode
  
  123456 - VB - SomeVBCode
  </code></pre>
  
  <p>I've added a column to the database called VB_Flag, which defaults to 0, which I would like to change to the number 1 for every ticket containing VB code. So, the result here would be:</p>
  
  <pre><code>123456 - SVR - SomeCode - 1
  
  123456 - VB - SomeVBCode - 1
  </code></pre>
  
  <p>But, I can't figure out for the life of me how to write this update query. At first I tried:</p>
  
  <pre><code>UPDATE table SET VB_Flag = 1 WHERE program_type = 'VB'
  </code></pre>
  
  <p>But that obviously left out all the SVR code that shared a ticket number with the VB code. </p>
  
  <p>I'm at a loss. Help?</p>