title: Get count of two column in access 2007
body: <p>TblAquestion:<br></p>
  
  <pre>
  AQcode(pk)|AQdescribe
  ---------------------------------
  1          do you want to continue?     
  2          what ..........?
  3          this is a ..........
  4          my name is a ali?
  </pre>
  
  <p><br>
  TblUserResult:<br></p>
  
  <pre>
  ID(pk)|AQcode_fk|Result
  -----------------------
  100    1         1
  101    1         0
  102    1         0
  103    1         0
  104    1         1
  
  105    2         1
  106    2         0
  
  107    3         1
  108    3         1
  109    3         1
  110    3         0
  
  111    4         1
  </pre>
  
  <p><br></p>
  
  <p>OutPut:</p>
  
  <pre>
  ResultYes is count of result where '1'
  ResultNo is count of result where '0'
  AQcode|AQdescribe                 |CountResultYes|CountResultNo
  ---------------------------------------------------------------
  1      do you want to continue?    2              3
  2      what ..........?            1              1
  3      this is a ..........        3              1
  4      my name is a ali?           1              0
  
  </pre>
  
  <p><br>
  SQL command?</p>