Report sorted by date but a space where the month changes (1 Viewer)

[RichO]

This should be pretty simple but I can't get it to work. I have a report that lists events in order by date. I want to use a group header or footer to create a space in the report anytime the month changes, so each month's dates are grouped together.

If I group by month and then sort by date, the report always starts with January. If I sort by date first, and then group by month, it inserts the header (space) between each DAY, not between each month.

I used Access 2000 for years and I used to be able to accomplish this without a problem but the sorting and grouping in Access 2010 is different so I am pulling my hair out over this.

Thanks for any help.

 

[Ranman256]

Why isnt group by month and then sort by date correct?
isnt that what you asked?

 

[RichO]

The report I am running lists dates from today forward and when you group by month it puts Jan 2017 first and November 2016 is grouped with November 2017 dates toward the end of the report.

 

[CJ_London]

sounds like you need to group by month and year, not just month

 

[RichO]

sounds like you need to group by month and year, not just month

Yeah, that's what it looks like. You would think it would be easier than doing all that

Thanks