title: CountIf formula within MS Access report
body: <p>Something terrible as happened with my poor attempt at adding a <code>CountIf</code> forumula to my access report.</p>
  
  <p>I am trying to add a formula within my report header to count the number of entries in my <code>Service</code> column that contain a certain word. The problem is I am an absolute amateur when it comes to SQL code. </p>
  
  <pre><code>=CountIf([Service]="Housing")
  </code></pre>
  
  <p>Is the code I was hoping would work but I don't seem to be getting anywhere.</p>