hi tab select Month(TimeStamp) , DayOfMonth(TimeStamp) , count(*) , count(distinct ClientIP) from RedirectLog where TimeStamp BETWEEN '20030130000000' AND '20030131000000' group by Month(TimeStamp) , DayOfMonth(TimeStamp) tell me if count(*) and count(distinct ClientIP) produce different numbers for your data rudy