Find Previous and next value in access using SQL
===

I am using a Microsoft Access 2010 database to import values from one table and append them to a summary table.

One of the issues I am having is finding the previous and next value from the select statement.

This would look as follows.

    JOINT          JOINT AHEAD             JOINT BEHIND
    100103           200203
    200203           300303                  100103
    300303                                   200203

I would like to create this using a SQL code