Using Month Name as Header

[Mitchy]

I am creating a schedule report that lists each job by its actual scheduled ship date. I want to add a header to group all the jobs for a single month together. What can I do to be able to use the actual name of the month, ie. November, in the header on the report?

Thanks,

 

[traingamer]

One way is to simply format it -

MonthName(DatePart("m",[your_date_field]))

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Mitchy]

Thanks, it works great.

 

[Mitchy]

Traingamer,

It was working great. Now when I go to print the report, it is asking me for MonthName, I hit enter leaving the space blank and then I get a error on the report. I did not change a thing. Is MonthName a function that coverts the numeric month into the month name? I cannot find out anything about this sort of function

 

[Blorf]

Maybe format (yourdate, "MMMM")

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[Mitchy]

It seems to be a problem with the MonthName function. The program is just not recognizing it.

 

[traingamer]

It was working great...

Was that in a query? Or a report? It should not stop working unless something changed.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill