LOL I wasn't gonna say anything... ;) Chris Blessing webguy at mail.rit.edu http://www.330i.net > select id, max([pleasetellmeyoudidn'tnameyourdatefield"Date"]) > from yourtable > group by id > > ;o) > > > rudy