Unless the Receipt, Reason, and Division fields are unique to the Item, you're going to have trouble due to how this is grouped. I can see item being unique within a Division, but I wouldn't necessarily count on it. What, exactly, does the Reason field bring into the result? Is that a return reason, a sales reason, or some other reason? I'm asking because you're grouping on it, and that might not be something unique to a given item. If you're looking for a SUM aggregate for a given item by day, then you need to only group by those fields. Once you determine where you have uniqueness, you can group by only those fields and get a good result. If you could post some CREATE TABLE statements and some INSERT statements with sample data and expected results, we can help much further.