title: MS Access multiple left joins
body: <p>I am trying to do two left joins and getting either a Syntax error or Missing operator error. I have 3 tables (DFM, Audit, Accounting Calendar).  I want to left join Audit and  Accounting Calendar table into DFM table (main table)</p>
  
  <p>Here is my current coding in Access:</p>
  
  <pre><code>FROM (([DFM report] 
  
  LEFT JOIN [Audit report] ON [DFM report].URN = [Audit report].URN)
  
  LEFT JOIN [Accounting Calendar] ON [DFM report].Receipt Date = [Accounting 
  Calendar].Date
  </code></pre>