Hi i am using the followig query :select count (*) from MEMBERS,dbo.MEMBER_PROFILE where MEMBER_PROFILE.member_no = members.member_no AND JOIN_DATE between '07-01-2013 00:01' and '07-31-2013 11:59'and email <> 'selfbuy_customer@cafepress.com'and ROOT_FOLDER_NO is not nulland email not like '%bvt.bvt'This returns the count for the month but I want to see what the total each day was.