Order groups by months

    I have a report that groups members birthdays by month. The report will list the groups in alphabetical order which is of course not what I want. I would like from Jan to Dec order. Any ides.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

    Re: Order groups by months


    Why not add the month number to the underlying query?


    You could group by that and you wouldn't actually need to show it on the report.

    Boo!:yikes:

    Re: Order groups by months


    Such an obvious answer, I feel silly for asking now. Thanks it worked great!

    [SIZE=2]I should change my name to STUMBED![/SIZE]

    Re: Order groups by months


    Hi,


    Not sure if your meaning of group is really the group/outline option or just sort.
    If sort you can use the Options and then specify the Months list to get months to be sorted in calendar order rather than alphabetically order.

    [h4]Cheers
    Andy    [/h4]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login