Convert a number to month

[Jerry]

I have a field with the month number (1-12). How do I
convert, say a 4 to read April in a report/form?

Thanks in advance.

Jerry

 

[Cheryl Fischer]

Try the MonthName() function:

MonthName(4, True) returns Apr

MonthName(4, False) returns April


hth,

 

[Douglas J. Steele]

Or if you're using an older version of Access that doesn't have the
MonthName function in it, try

Format$(DateSerial(2000, MonthNumber, 1), "mmm")
or
Format$(DateSerial(2000, MonthNumber, 1), "mmmm")