I'm trying to group by the Department, Date only (not time), and accepted. Here's my query: And also....you said you wanted to group by department and date and accepted...but then you said the accepted column wasn't summing. You really can't group by accepted AND sum accepted in the same query. So I'm not 100% sure I understand what you're trying to do.
And also, Naomi was right, I think you're using ISNULL backwards.