title: Data Type Mismatch In Criteria Expression (Access 2013)
body: <p>I have an access database with linked excel tables( each table is an excel sheet)
  In one of my tables, there is a currency field called 'Salary'. The format is <strong>$#,##0.00</strong>. As such, for cases where salary is 0, the field value is <strong>$0.00</strong>.</p>
  
  <p>I wrote a query to exclude records where the salary value is 0. In the criatera box, i plase &lt;> "$0.00", however when I run the query, i receive the error <strong>Data Type Mismatch In Criteria Expression</strong>. 
  Any help would be appreciated.</p>