>>>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 ? :)
There are far too many discussion boards and languages to be able to keep up anymore. I don't understand how you can find the time.