title: Using AND criteria on text field in MS Access
body: <p>I am trying to create/design a query in MS Access. I'm sorry I don't know the correct terminology of what I am trying to do. I am trying to update some inventory and my data looks like this. </p>
  
  <pre><code>Music Table
  item no.  Record Status
  01           DELETE
  02           DELETE
  03           DELETE
  04           DELETE
  07           DELETE
  01           ADD        
  04           ADD
  06           ADD
  </code></pre>
  
  <p>In my data items that have both DELETE and ADD are updates. I am trying to write a query to create a table filters these particular items. Any suggestions? I tried using the Query Design View.
  Field -> Record Status,Table-> Music Table and put 'DELETE' And 'ADD' in the Criteria but it just showed me a blank table.</p>
  
  <p>Any suggestions?</p>