title: Dcount in Microsoft Access expression
body: <p>I've been trying to get dcount to work in an existing database with queries and report names that are the same and was giving myself a headache, so I created a simple 1 table db to test it out.</p>
  
  <p>It has a field1 with these values
  id1
  id1
  id2
  id3</p>
  
  <p>I want to count the number of distinct values.  i.e. get 3 from the above.
  I created a report with a field in the report footer with the expression </p>
  
  <pre><code>=DCount("[Field1]","Table1")
  </code></pre>
  
  <p>..it returns 4</p>
  
  <p>Yet when I check the microsoft site for the description of how dcount works, it distinctly says it counts distinct entries.<br>
  Can someone clarify?</p>