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.
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.