Hi Recyan,
Sorry i'm a newbie,
so i not quite understand where to put in your code.
But i played with the Where function
just like you mentioned and it seems working.:D
i did the following :
instead of group by >=[beginDate] and <=[EndDate]
i used Where >=[beginDate] and...