title: Access SQL query needed (dates)
body: <p>So i have the following query:</p>
  
  <pre><code>DoCmd.RunSQL "delete * from [TABLE NAME] where month = '" &amp; Format(PrevMonth, "yyyy-mm-dd") &amp; "'"
  </code></pre>
  
  <p><code>month</code> is a Text field. </p>
  
  <p>Lets say <code>PrevMonth = August 2010</code> so instead of delete the rows where the date is august 2010, i want it to delete august 2010 and all after that?  so september 2010, october 2010, and so on.</p>
  
  <p>thanks.</p>