Hi ,
I would prob create a working table to start the ID's of the records witht he Max dates for each change in the name.
I would then delete from the Main table where the ID's are not in the Working table.
Does this make sense?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]