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
