Update end date to next record's beg date

[supmktg]

I have a table of Transfer and Return dates for items that are moved between locations. The table includes the following Fields:

RecordID
ItemNo
LocationNo
TransferNo
TransferDate
ReturnNo
ReturnDate

I need to update the ReturnNo & ReturnDate for each record to the TransferNo & TransferDate of the next record for that same ItemNo (if there is a next record for that ItemNo).

How would I do that?

Thanks,
Sup