Group/Sort by date 1

[MICKI0220]

I have a report where I group by month, however it does not put in order by month then year. For example February 2007 shows up before November 2006. How can I make this work the right way.

 

[dhookom]

What are you using in the Sorting and Grouping expression? Are you actually attempting to sort on the month name rather than the month number? Do you want to sort by Year and then month number?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MICKI0220]

In the sorting and grouping field I have it set to group on the fld "MTH" which is a number, then it converts it as a display.

 

[dhookom]

Do you want to sort by Year and then month number?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MICKI0220]

Yes. I do.

 

[dhookom]

Then set up the sorting and grouping to first the year of a date and then the month of a date. An alternative is to set your sorting and grouping to something like:
=Format([DateField],"yyyymm")

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MICKI0220]

Thank you, I got it.