----- Original Message ----- From: "Jay Blanchard" <jay.blanchard at niicommunications.com> Sent: Wednesday, December 17, 2003 4:30 PM > *shimmering* A cross-tab query perhaps? Jay, The answer may be easier than you think. SELECT datediff(d,duedate,getdate()), Count(*) AS TheCount FROM tasks GROUP BY datediff(d,duedate,getdate()) Best of luck, <><><><><><><><><><> Joshua Olson Web Application Engineer WAE Tech Inc. http://www.waetech.com/service_areas/AZ/ 706.210.0168