Setting Month order in a report? 2

[Dedicated]

I have a report in which the Month is grouped with team listings and status of each team. Presently I have it set up under the "Sorting & Grouping" as "Descending" but I really need the report to show month by order...January, February, March, April, etc. instead of my "descending" order (March, January, February, etc.).

Thanks,

Dedicated

 

[SkipVought]

Hi,

try
[tt]
...
Order by Format([MyDate], "mm")
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[jebry]

Hi!

Actually what you need to do is:

Order By Month([YourDate])

Month returns a number 1 through 12 for Jan - Dec so it will give you the correct order.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[Dedicated]

Jeff:

Where do I plug this in? Do I need to delete the Month from the Sorting & Grouping box?

 

[jebry]

Hi!

I would add this to the query the report is based on. Then it will be available for grouping and sorting.

hth


Jeff Bridgham
bridgham@purdue.edu