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.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums