Question Locked

Group by Month and Sort in Month Order - MS Access

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All
I have created parameter queries asking for a Start Date (eg: March 2007) and an End Date (eg: February 2008). In the query I have managed to get it to sort in Month (Date) order by using:
Year(Payments.DateOfPay)*12+DatePart('m',Payments.DateOfPay)-1 AND
DateOfPay By Month: Format$([Payments].[DateOfPay],'mmmm yyyy')
HOWEVER, when I create report based on the query and add a total to the report it sorts in Alphabetical order. Why? I am at my wits end with this!! Thanks, Sharon

2 replies

by john.a.wills

When in Designer mode on the report click the reporting & grouping icon (next to the toolbox icon) and see what values you have listed. Change the values to what you want.

This discussion is closed to new replies.