if I understand you correctly, this should do it.
select distinct office, max(dateposted) from table group by office
Just one more thing. You don't need "distinct" because you are already using "group by".
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]