Update fields within a Table

[Greg]

I have a situation I can not solve. Maybe someone can give some advice.

I have an Access 2000 table with aprox. 2600 rows(records). There are about
20 fields/columns in each record.

There has been a major change to data I receive monthly via several CDs. The
best way for me to explain my situation is through an example:

Table A

Rec 1
Field1 Value = 1111111111
Field2 Value = 05/01/2006
Field3 Value = rrr27
Rec 2
Field1 Value = 1111111111
Field2 Value = 06/01/2006
Field3 Value = rrr27
Rec 3
Field1 Value = 1111111111
Field2 Value = 07/01/2006
Field3 Value = rrr27
Rec 4
Field1 Value = 1111111111
Field2 Value = 08/01/2006
Field3 Value = ABC234

Field1 and Field2 are primary keys. Is there any way I can use the value in
Rec 4 Field3 and place in Field3 of Rec1,2,3 ??
The next group of records would have a different field1 value and could have
records 1,2,and 3, because one of the months(Field2) was not sent to me.



Thank You,
Greg