select '6/12/2007-6/18/2007' as 'dateRange',count(*) as count from tblBlacklist where Date_Added between '6/12/2007' and '6/18/2007' UNION ALL 
select '6/5/2007-6/12/2007' as 'dateRange',count(*) as count from tblBlacklist where Date_Added between '6/5/2007' and '6/12/2007' UNION ALL 
select '5/29/2007-6/5/2007' as 'dateRange',count(*) as count from tblBlacklist where Date_Added between '5/29/2007' and '6/5/2007' UNION ALL 
select '5/22/2007-6/29/2007' as 'dateRange',count(*) as count from tblBlacklist where Date_Added between '5/22/2007' and '5/29/2007'