title: Comparing date in Access SQL query
body: <p>I'm having trouble with Access sql query. Im new to this so bieng a rookie its difficult to figure out the syntax. below is my query.</p>
  
  <pre><code>SELECT *
  FROM BookingMaster WHERE JourneyDate = #01/08/2012#;
  </code></pre>
  
  <p>below is the respective table data:</p>
  
  <pre><code>BookingID   BookingDate    JourneyDate   CustomerName   TelephoneNo  Address
  5            01-08-2012     01-08-2012         roshan         78889     hjgj    
  </code></pre>
  
  <p>the above query listed returns 0 results even though data exist for 01/08/2012 journey date.</p>
  
  <p>Can anyone please help me out.</p>