> SELECT > TOP 1 LogonDate > FROM > myTable > GROUP BY > ComputerName > ORDER BY > LogonDate DESC that'll just give one date ;o) try this -- select pc_ID, max(LogonDate) from myTable group by pc_ID order by pc_ID rudy