title: Cannot figure out SQL Select statement in Access 2016
body: <p>I'm having some trouble understanding WHY a select statement isn't working in a query I'm making.</p>
  
  <p>I've got the <code>SELECT</code> and <code>FROM</code> lines functioning. With just those, ALL results from my selected table are displayed - 517 or so</p>
  
  <p>What I want to do is display results based on a pattern using LIKE - What I have so far</p>
  
  <pre><code>SELECT *
  FROM Tbl_ServiceRequestMatrix 
  WHERE Tbl_ServiceRequestMatrix.[Application/Form] LIKE 'P%';
  </code></pre>
  
  <p>This returns 0 results - despite the fact that the column selected DOES have entries that start with 'P'</p>
  
  <p>I also tried utilising brackets, see if that was the issue - still displays 0 results:</p>
  
  <pre><code>SELECT  *
  FROM Tbl_ServiceRequestMatrix
  WHERE ((Tbl_ServiceRequestMatrix.[Application/Form])='p%');
  </code></pre>
  
  <p>Can any one help me understand why my <code>WHERE ** LIKE</code> statement is causing 0 results to be displayed?</p>