>>It depends on what do you want to achieve, do you want just one Max record doesn't matter which or multiple.
>
>I will be using a datetime for the changedate so it shouldn't matter, but I concede the point.
>
>Thanks!
You're welcome.
BTW, how did you miss this recent discussion
http://www.tek-tips.com/viewthread.cfm?qid=1367284&page=1 ? :)
If it's not broken, fix it until it is.
My Blog