title: How to use DCOUNT on select- sql query while using group by?
body: <p>How to use DCOUNT on select- sql query while using group by?</p>
  
  <p>I have a problem and first, I want to show part of the real table
  ![I WANT a query that show me per date the amount of bl_no in feedback_status=”99” , the amount of bl_no is feedback_status=”1”</p>
  
  <p>I try to wrote this code in sql query on MS ACCESS and I don’t get the result that I want</p>
  
  <pre><code>SELECT CUSTOM_TRANSMISSION_DATE, dcount("*","M_MAAGAR_BL_CUSTOM_TRANSMISSION_LOG","FEEDBACK_STATUS=0") 
  FROM M_MAAGAR_BL_CUSTOM_TRANSMISSION_LOG
  GROUP BY CUSTOM_TRANSMISSION_DATE;
  </code></pre>
  
  <p>Can you help me?</p>
  
  <p><a href="http://i.stack.imgur.com/s9ndn.jpg" rel="nofollow">Image</a></p>