Sorting/Grouping question on report

[Slez via AccessMonster.com]

I have a report in an Access 2002 Db that displays data from the past 12
months. I have grouping levels set for the month and week, and as a result
it returns in a monthly order as follows:
January 2008
February 2008July 2008
August 2007
September 2007December 2007

I obviously would like it to begin with August 2007 and follow through to
July 2008. My current sorting/grouping levels are set to the following:
=DatePart("m",[BidDate]) - Ascending
=DatePart("ww",[BidDate]) - Ascending
BidDate - Ascending
...and so on...

I've tried adding a grouping level ahead of the "m" group with no group
header or footer like:
=DatePart("y",[BidDate]) - Ascending

This returned data incorrectly on the report. It seemed to display a
separate grouping for each BidDate. I'd like it to group the same as
currently but sort by beginning with the oldest date (i.e. August 2007).
Any suggestions on how to achieve this would be greatly appreciated.
Thanks!

 

[Allen Browne]

You're making this harder than it has to be.

Assuming BidDate is a Date/Time field (not a text field), in the
Sorting'n'Grouping dialog, choose the BidDate field. In the Lower pane of
the dialog, set the Group On property to "Year."

Then on the next row of the Sorting'n'Grouping dialog, choose BidDate again.
This time, Group on "Month."

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report in an Access 2002 Db that displays data from the past 12
months. I have grouping levels set for the month and week, and as a
result
it returns in a monthly order as follows:
January 2008
February 2008July 2008
August 2007
September 2007December 2007

I obviously would like it to begin with August 2007 and follow through to
July 2008. My current sorting/grouping levels are set to the following:
=DatePart("m",[BidDate]) - Ascending
=DatePart("ww",[BidDate]) - Ascending
BidDate - Ascending
..and so on...

I've tried adding a grouping level ahead of the "m" group with no group
header or footer like:
=DatePart("y",[BidDate]) - Ascending

This returned data incorrectly on the report. It seemed to display a
separate grouping for each BidDate. I'd like it to group the same as
currently but sort by beginning with the oldest date (i.e. August 2007).
Any suggestions on how to achieve this would be greatly appreciated.
Thanks!

 

[Slez via AccessMonster.com]

Allen:
"You're making this harder than it has to be."

...which is exactly why I prey on the knowledge of this forum!...
Thanks so much for the help! That worked perfectly!

Slez

You're making this harder than it has to be.

Assuming BidDate is a Date/Time field (not a text field), in the
Sorting'n'Grouping dialog, choose the BidDate field. In the Lower pane of
the dialog, set the Group On property to "Year."

Then on the next row of the Sorting'n'Grouping dialog, choose BidDate again.
This time, Group on "Month."

I have a report in an Access 2002 Db that displays data from the past 12
months. I have grouping levels set for the month and week, and as a

[quoted text clipped - 25 lines]

Any suggestions on how to achieve this would be greatly appreciated.
Thanks!