Well, Dt Last Received across each line will be different because that is where the deltas are in these rows, but I need that column as I need to display...

Okay, so what I did was a Max() CASE WHEN the Date Last received=9999999 I change it to '999' that way it will be lower than any other valid date...

Hello,

Thank you for the replies. I will attempt the methods provided.

I have to apologize, I should have included that in my initial post that the...