<quoth Joshua Olson:> The answer may be easier than you think. SELECT datediff(d,duedate,getdate()), Count(*) AS TheCount FROM tasks GROUP BY datediff(d,duedate,getdate()) </jo> Hot diggity! Shoulda thunk of that meself joel