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!
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?
Access 2000 or later
=MonthName([MthNumberField])
All Versions:
=Format(DateSerial(2000,[MthNumberField],1),"mmmm"
Or
=Choose([MthNumberField],"January","February",....)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.