John,

You are right I did mean to say I wanted the most recent record and not the oldest record with the DATEOUT field.

Tim

Flo,

This is what I need.

Thank You,

Tim

1. I would use the max(DATEOUT) to determine to update FIELD as I want the the value from the oldest record.

2. Yes the values already in the #TEMP...

Flo,

This does not give me what I want. I need to use the values in in the #TEMP also to be used to determine the earliest DATEIN and...