lookup procedure

[jprma]

Hi, I am creating a database for my Office used to store data referred to the work we handle every month. It has a statistical purpose.
I have created a form (named FORM1)to add data to a table name TABLE1. This table has the following fields (number property):
DATE
PREVIOUS PENDING
NEW CASES
CURRENT PENDING
CLEARED CASES
The DATE field is used to add the current month to which data refer.
The PREVIOUS PENDING field is used to indicate the total number of cases that the month prior to the one indicated in the DATE field, we did not finish to work. It is used as a reminder of ou pending work.
The CURRENT PENDING indicates all work that during this current month we have not cleared.
What I would like is that each time I add a new record to the table, the PREVIOUS field would automatically store (or lookup) the data stored in the CURRENT field of the previous record.
Example:
Say the first record reflects the month of 01/01/2000. In the DATE field I will store 01/2000 and the the CURRENT PENDING I will store the value 10.

When I add a new record to the following month 02/2000, I would like the the value 10 previously stored in the CURRENT PENDING field, would be now stored in the PREVIOUS PENDING field.

Is there a way I can to this and how.

Thanks