title: How to output a boolean from a query
body: <p>In MS Access 2007 (using Access 2000 format) I am attempting to get a boolean output from a query such that the result is displayed as a checkbox rather than 0 or -1.</p>
  
  <p>When the query is passing along a boolean input, this is working properly.  When I attempt to make an evaluation, the result is 0 or -1, but not a TRUE/FALSE checkbox.</p>
  
  <p>I have tried:</p>
  
  <pre><code>SELECT (MyInt &gt; 1) AS MyBoolResult
  SELECT CBool(MyInt &gt; 1) AS MyBoolResult
  SELECT IIF((MyInt &gt; 1), TRUE, FALSE) AS MyBoolResult
  SELECT CBool(IIF((MyInt &gt; 1), TRUE, FALSE)) AS AS MyBoolResult
  </code></pre>
  
  <p>In each case my result is a 0 or -1, and I cannot get this into a display checkbox down stream in an ASP .Net web page using a GridView.</p>
  
  <p>Is what I want possible?  If so, how is it accomplished?</p>