Grouping by Dates in Reports

[MasterDeb]

I have a report where I'm grouping by the month on a date field and it groups correctly. Under the group heading I have a =Format([field],"mmm") field. My goal is to have the group so the Month name. As in January, February and so forth.

It is grouping correctly but instead of showing each month name, its only showing January and some times December. But I have all most every month that should be showing.

I have another report where this works, I've copied it exactly, but cannot figure out what is wrong with this new one. Any ideas??

Thanks,
Deb

 

[vbaInet]

Deb,

You can use the MonthName() function or the Format() function.

MonthName goes something like this:

MonthName(Month([DateField]))

 

[MasterDeb]

I have tried both. Mainly the Format function as stated in my post. That is what is giving me January for every grouping. My groups are correct and separating correctly, the heading is just only showing January for every group.

The Month function gave me an error.
Any other ideas?
Deb

 

[vbaInet]

You apply the Month function on the raw date/time field. Not on the Formatted field.

* Group on Month([DateField])
* Display MonthName(Month([DateField]))

 

[MasterDeb]

I've done that. I'll try again.