title: Count occurrences in Access query
body: <p>I am looking to see if its possible to run a count in an Access Query.</p>
  
  <p>I have a list of data under <code>TeamName</code></p>
  
  <pre><code>TeamName
  ----------
  Liverpool
  Liverpool
  Liverpool
  Liverpool
  Liverpool
  Manchester
  Manchester
  Newcastle
  Newcastle
  Stoke
  Stoke
  Stoke
  </code></pre>
  
  <p>I would you like a formula in Access that counts the number of occurrences in chronological order, so like below</p>
  
  <pre><code>TeamName    Count
  --------    -----
  Liverpool     1
  Liverpool     2
  Liverpool     3
  Liverpool     4
  Liverpool     5
  Manchester    1
  Manchester    2
  Newcastle     1
  Newcastle     2
  Stoke         1
  Stoke         2
  Stoke         3
  </code></pre>
  
  <p>I've added a screenshot to see if that helps<a href="https://i.stack.imgur.com/xCe8p.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xCe8p.jpg" alt="enter image description here"></a></p>