title: Remove last characters after last space in a string
body: <p>I'm having string values like mentioned below.</p>
  
  <p><strong>String Values:</strong></p>
  
  <blockquote>
    <p>George, Matt J</p>
    
    <p>Rambla, Tony G.</p>
  </blockquote>
  
  <p><strong>Expected Output:</strong></p>
  
  <blockquote>
    <p>George, Matt</p>
    
    <p>Rambla, Tony</p>
  </blockquote>
  
  <p>I would need to trim the letters like mentioned above. Can anyone help me with this?</p>
  
  <p>I achieved the same in SQL Server by below query</p>
  
  <pre class="lang-sql prettyprint-override"><code>declare @String as varchar(20) = 'Rambla, Tony G.'
  
  select left(@string,len(@string)+1-charindex(' ',reverse(@string))) 
  </code></pre>
  
  <p>How can I achieve this in MS Access?</p>
  
  <p>I have tried these and doesn't help</p>
  
  <p><strong>1st Method</strong></p>
  
  <pre class="lang-sql prettyprint-override"><code>Left([ColumnName], Len([ColumnName]) -1)
  </code></pre>
  
  <p><strong>2nd Method</strong></p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT LEFT(ColumnName, INSTRREV(ColumnName, " "))
  </code></pre>