title: MS Access SELECT query DatePart
body: <p>i have some problem with my SELECT Query to MS Access .mdb file.</p>
  
  <p>i am using VB.Net and have to send query like..</p>
  
  <pre><code>"SELECT d_date, d_tons, d_qty, d_cost FROM [deal] WHERE DatePart(""m"", [d_date]) = '" _
  + DTP.Value.Month.ToString + "' AND ([d_client] = '" + cBoxClient.Text + "')"
  </code></pre>
  
  <p>But it doesn't work.. No Error in compiling but this Query cannot SELECT any data.</p>
  
  <p>DTP is DateTimePicker, i select Month with DTP and filled some text into cBoxClient(ComboBox)</p>
  
  <p>What's wrong with that Query? i have no idea because i always used MySQL and this is my first application development with MS Access..</p>
  
  <p>Please HELP me.</p>