~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "rudy" <rudy937 at rogers.com> Subject: Re: [thelist] SQL query by dates : > SELECT : > TOP 1 LogonDate : > FROM : > myTable : > GROUP BY : > ComputerName : > ORDER BY : > LogonDate DESC : : that'll just give one date ;o) : Oops. What rudy said. Cheers Ken