Group by Month and Sort in Month Order - MS Access

By pctrain ·
Hi All
I have created parameter queries asking for a Start Date (eg: March 2007) and an End Date (eg: February 200. 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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums