title: Find Previous and next value in access using SQL
body: <p>I am using a Microsoft Access 2010 database to import values from one table and append them to a summary table.</p>
  
  <p>One of the issues I am having is finding the previous and next value from the select statement.</p>
  
  <p>This would look as follows.</p>
  
  <pre><code>JOINT          JOINT AHEAD             JOINT BEHIND
  100103           200203
  200203           300303                  100103
  300303                                   200203
  </code></pre>
  
  <p>I would like to create this using a SQL code</p>