title: Query Select group by last character in field
body: <p>I'm trying to do a query search on a table and return a count of rows that end in the same character.  For example, Cd312a, fdhEA and 42dA would be grouped together under 'A'.  Below is an example of the table and what I would like to see returned.</p>
  <p>Table Tbl_Table</p>
  <pre><code>ID| _Name     |
  1 | S033114A  |
  2 | S033114B  |
  3 | S033114B  |
  4 | S033114K  |
  4 | S033114K  |  
  </code></pre>
  <p>Results</p>
  <pre><code>Type  | Count
    A   |  1
    B   |  2
    K   |  2 
  </code></pre>
  <p>My Current Code</p>
  <pre><code>SELECT RIGHT(_Name,1) as Type, Count(Type) as Count FROM Tbl_Table
  </code></pre>
  <p>Anyone that can shed some light on my my query isn't returning what I am expecting would be helpful.  Thank you.</p>