title: How to filter a query with partial string matches in Access
body: <p>I'm using the below code to filter a query, however it only returns exact matches. If I want to look at every person with John in their name, how would I change this?</p>
  
  <pre><code>With Me
      .Filter = "[Initiator's Name]='John'"
      .FilterOn = True
  End With
  </code></pre>