Group Report by Day not month?

[bradleyg]

Hi and thanks for looking at my question. I have a simple report that shows number of cases and the time they are packed


example

2 9.16.13 8:00 AM
10 9.16.13 8:15 AM
4 9.17.13 6:00 AM
10 9.17.13 6:10 AM
and so on

I created a report with the report wizard and I grouped by date (and it put the date in the top (Date by month)) is there a way to have it group by day? when I run the report it shows all data grouped by month and I need it to group by day.
FYI the date header is showing =Format$([ModDate],"mmmm yyyy",0,0) can I assume that's why its grouping by month? Can I change that to group by day??
the reason is I added a Sum and need it to sum the total cases packed by day not month. so 9.16 would be 12 and 9.17 would be 14

thanks

Brad

[bradleyg]

I figured it out myself (for once) Just change the group details to by day not month. Did not see that option when building the report

[mrojas]

Please flag it as Solved.