title: DCount in Access VBA
body: <p>I have a table that I would like to perform a counting operation to summarize its contents.  The DCount function should work, but I cannot get the syntax correct even though it appears to match examples that I have found online.
  Table: tblIGEMS
  Field to Sum from: Squadron</p>
  
  <p>VBA Formula:</p>
  
  <pre><code>DCount("[Squadron]", "tblIGEMS", "[Squadron] = xyz")
  </code></pre>
  
  <p>Any help would be greatly appreciated</p>