Month Numbers

[xianman]

For some reason I am unable to find how to convert the # results of months, to the actual name of the month on a report. Is this possible? I have looked all over. Thanks!

 

[tjl99a1]

Xianman,
Not sure if this is what you want, you can create a label in design view and place next to the results, ex Jan. [results]123 or when you create your text box, name it as such. Is this what you need?

 

[Norris68]

Have you tried the MonthName function?

 

[dhookom]

Access 2000 or later
=MonthName([MthNumberField])
All Versions:
=Format(DateSerial(2000,[MthNumberField],1),"mmmm&quot
Or
=Choose([MthNumberField],"January","February",....)

Duane
MS Access MVP