title: Date Difference between consecutive rows
body: <p>I have a table with following structure</p>
  
  <pre><code>ID     Account Number     Date
  1      1001               10/9/2011 (dd/mm/yyyy)
  2      2001               1/9/2011 (dd/mm/yyyy)
  3      2001               3/9/2011 (dd/mm/yyyy)
  4      1001               12/9/2011 (dd/mm/yyyy)
  5      3001               18/9/2011 (dd/mm/yyyy)
  6      1001               20/9/2011 (dd/mm/yyyy)
  </code></pre>
  
  <p>Basically what i would like to do is have an access query that calculates the date difference for consecutive records but for the same account number
  The expected result would be !!</p>
  
  <pre><code>1001      10/9/2011 - 12/9/2011     2 days
  1001      12/9/2011 - 20/9/2011     8 days
  1001      20/9/2011                 NA
  </code></pre>
  
  <p>Basically what i would like to do is have an access query that calculates the date difference for consecutive records but for the same account number , in the above example would be 1001. (the dates don't have to be shown in the result)</p>
  
  <p>I use access 2003.</p>