> > You can use DATEPART to extract the parts of the date > I tried various combinations like that. I have DATEPART in the select, but then I get syntax errors in the HAVING because I can't put DATEPARTs into it.
I can't figure out how to group and sum on "parts" of a DateTime column. I'll try to provide a tiny sample when I get home this evening. Greg K
