title: Joining date fields from 2 separate tables in Access 2010. Outer join is acting like an inner join
body: <blockquote>
    <p>Blockquote</p>
  </blockquote>
  
  <p>I am joining date fields from 2 separate tables in Access 2010.   In 'Join properties' i am including all records from the table on the left, and only those records that match from table on right.   For some reason it is treating it like a regular join where only records that match from both tables appear.  Example: Left table has 31 records for every day in May - May 1 - May 31 2015.  Right table has only 19 records with dates in May plus other fields i want to see when there is a match.  When i run the query it returns only 19 records, not the 31 records i am expecting.   I've confirmed both tables are formated for dates, and even tried changing data type using 'Clng' to confirm the records match.   I am using 'Design' view of query - i'm not at all good with Sql or Vba.   All the sites i've searched refer to this problem using SQL..</p>
  
  <p>SQL below for those who can work with this:</p>
  
  <pre><code>SELECT 
      [Raven Download 10 table].Region
      , [Raven Download 10 table].Market
      , [Raven Download 10 table].Location
      , [Date table].dDate
      , [Raven Download 10 table].SessEndDate
      , [Raven Download 10 table].MaxOfDwnldStat
  FROM 
      [Raven Download 10 table] 
  RIGHT JOIN 
      [Date table] 
  ON 
      [Raven Download 10 table].SessEndDate = [Date table].dDate
  WHERE 
      ((([Raven Download 10 table].Location)="hay river"));
  </code></pre>