title: sql query to select week,month, days
body: <p>please guys, i need an sql query to select data from an access database using vb6. the query will only provide current date and the filed been compaired is curr_date in the database.</p>
  
  <p>for example</p>
  
  <pre><code>SELECT * 
    FROM TABLE 
   WHERE curr_date BETWEEN firstoflastmonth AND endoflasthmonth;
  
  SELECT * 
    FROM TABLE 
   WHERE curr_date BETWEEN firstoflastweek AND endoflasthweek;
  
  SELECT * 
    FROM TABLE 
   WHERE curr_date BETWEEN firstofthismonth AND endofthismonth;
  
  SELECT * 
    FROM TABLE 
   WHERE curr_date BETWEEN firstofthsiweek AND tilldate;
  </code></pre>
  
  <p>The problem i have figuring ot is how to specify the two dates in comparison</p>