>Hi Folks, Thanks for all your replies.
>I thought I would keep it simple by showing a sample where there were
> just two fields... in reality there are more than the two fields.
>I note that there is a different solution if there are more than 2 fields !!!
>I'll take that into account.
>
>Thanks again
>Regartds.
>Gerard
>
Please see this problem analyzed in details in this blog
5 ways to get last date record information in SQL Server
If it's not broken, fix it until it is.
My Blog