title: DCount with 2 criteria
body: <p>I am using <code>DCount</code> to help display an error message if the data signals an error.  I have it working with one criteria where a number is equal to another number.  Now I wanted to add another criteria in there where another field, <code>ReturnDate</code> (this field is Text not Date/Time) is equal to a hyphen (-).
  I'm just not really sure how to format it.  I have this:</p>
  
  <pre><code>If DCount("*", "CrewTable", "KitNumber=" &amp; _
    Me.AssignKit.Value And "ReturnDate=" &amp; _
    "-") &gt; 0 Then
    Cancel = True
    MsgBox "Kit is already assigned!"
    AssignKit = ""
    AssignKit.SetFocus
  Else
  ...
  </code></pre>
  
  <p>The error pops up with a 'Type Mistmatch' and the debugger highlights the whole statment from 'If -> Then' and has an error pointing to the line with the hyphen in the quotes.</p>