title: Access get a list and total count of distinct items
body: <p>I've been trying to find an Access version of the subject and testing many concepts.  All I want to do is what I thought was simple.  Let's say I have a single column in a table.  Values are like</p>
  <p>California
  Florida
  California
  California
  New York
  California
  New York</p>
  <p>let's leave it that simple.  All I'm trying to do which seems easy in SQL Server or Oracle is show the distinct values and how many times they are referenced in the table.  So output would be:</p>
  <p>California  4
  Florida  1
  New York 2</p>
  <p>On Access 2019 if it matters.</p>