update record with data from another record in same table

[jmstur2]

How do I update a field in a record based on the value of another field in another record - in the same table?

Specifically, I want to update the value in the AMOUNT field of record1 with the value of the AMOUNT field in record 2 when the value in the YEAR field of record 2 meets a certain criteria. In addition, the records also have to match on 2 other fields

Thanks.

[ck9663]

Kindly post what you have done so far. Some sample data will also be great, together with your desired output.

-- CK