Unanswered: Why do I have to use the Groupby with the DatePart function?
I was using the DatePart function for one of my query i'm doing. I had this problem where if I don't use the groupby, it would pull up the other months as well.
For example, if I choose in the combo box for the month of June and when I run the query, it would pull up June and other months as well. But when I use the groupby, I don't see the other month but JUNE. Why is that?