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

RichO

Registered Yoozer
Local time
Today, 04:19
Joined
Jan 14, 2004
Messages
1,036
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

Well-known member
Local time
Today, 05:19
Joined
Apr 9, 2015
Messages
4,337
Why isnt group by month and then sort by date correct?
isnt that what you asked?
 

RichO

Registered Yoozer
Local time
Today, 04:19
Joined
Jan 14, 2004
Messages
1,036
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

Super Moderator
Staff member
Local time
Today, 09:19
Joined
Feb 19, 2013
Messages
16,553
sounds like you need to group by month and year, not just month
 

RichO

Registered Yoozer
Local time
Today, 04:19
Joined
Jan 14, 2004
Messages
1,036
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
 

Users who are viewing this thread

Top Bottom