Grouping with Date field

[hkimpact]

Hello everyone -

I have a query with 4 Fields (Category, Time, CategoryCount, and Date). I want this query to group by category, Sum the time for the category, display a count of each category. If I remove the Date field from my query, this will result in pulling all the information in my table(s).

I don't want it to show all the data though. I want to use a between date1 and date2 statement in the criteria. But doing this results in losing my grouping of the categories.

I'm going to post a picture to show a result of how it looks. Maybe it will give you a better idea of what I want.

I understand why the date is causing my problem, but can someone introduce me to a way that will work around this problem?

Thank you!

 

[boblarson]

uncheck the SHOW check box on the Date1 Field and change GROUP BY to WHERE.

 

[hkimpact]

Thanks Bob! I was just thinking about SQL and the WHERE statement. Not sure why I didn't try this haha.